Jet Reports provides the ability to use Friendly Names if you are using a Universal Connector. Often times the field and table names defined in your database are not as intuitive as you might wish. Friendly Names gives you the ability to define your own names for the fields and tables in your database and then use them in Jet Reports. In order to use this functionality you will need to add three tables to your database: JETFPG, JETTMAP, and JETFMAP and then configure your Jet Reports data source to use Friendly Names.
JETFPG holds the Friendly Name Group. Groups give you the ability to have multiple Friendly Names for a single table or field. This would be useful for translating your tables and fields into multiple languages.
JETFPG table definition
Field: FPG JETNAME Type: Integer VarChar Primary Key: Yes Yes Description: Number uniquely identifying the Friendly Name Group Name of Friendly Name Group
JETMAP maps the existing table name to a Friendly Name and Group
JETMAP table definition
Field: FPG TFN TPN Type: Integer VarChar VarChar Primary Key: Yes Yes No Description: Number uniquely identifying the Friendly Name Group Friendly Name of the Table Table Name as defined in the database (actual table name)
JETFMAP maps the existing field name to the table it is on as well as the Friendly Name and Group
JETFMAP table definition
Field: FPG TPN FFN FPN Type: Integer VarChar VarChar VarChar Primary Key: yes Yes Yes No Description: Number uniquely identifying the Friendly Name Group Table name as defined in the database (actual table name) Friendly Field Name Field Name as defined in the database (actual field name)
Once these three tables have been added and populated with your desired Friendly Names you will be able to use either Friendly or Actual names in your Jet Reports.