Install Friendly Table or Field Names in a Universal Data Source

This information applies to the Jet Universal Connector (not Dynamics GP or NAV).

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.

1. JETFPG

   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

2. JETMAP

   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)

3. JETFMAP

   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.