Skip to Content
author's profile photo Former Member
Former Member

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

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Dec 22, 2008 at 03:38 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.