Search code examples
crystal-reports

change relationship between tables in crystal reports after creating it

I have created a crystal report and imported 3 tables and also set relationship between them using Standard Report Creation Wizard. Now I want to change relationship between tables. But how can I change it? (e.g. how to start Standard Report Creation Wizard again?)

Solution

  • Database | Database Expert... to

    • adding and removing tables
    • changing table names
    • modifying linkage
    • creating a Command (a 'raw' SQL statement)

    Database | Set Location... to:

    • change the data source (change from one database instance to another) for main and subreports
    • see the details of each table's connection