Did table mapping exist in CR (CR XI + Foxpro 9 + ADO OLEDB VFP)

[Former Member]

My development environment is:

Windows 2000 professional + Foxpro 9.0 + Crystal Report XI

I built the report using OLE DB (ADO), Microsoft OLEDB provider for Visual Foxpro, that contains 2 tables.

I successfully change the data source to another tables with the same table names in different directory. But I want a different table name. Is it possible for Crystal Report to have a table name mapping, etc. It could be any version XI or 2008.

[former_member183750]

To change the table name at runtime using the RDC, we will need to use the "Location" property of the Tables object.

Eg:

Report.Database.Tables(1).Location = "authors" 'authors is the first table in the report.

Therefore, if you are changing from a report that contains fully qualified table names to a report that does not use these fully qualified names, we will have to loop through the tables, changing the names.

Eg:

Report.Database.Tables(1).Location = "authors"

Report.Database.Tables(2).Location = "books"

Report.Database.Tables(3).Location = "publisher"

Ludek

[Former Member]

Thank you Ludek Uher. It works