Union of queries in Crystal

[KeertanaCR]

Hello All,

I have a report built on tables. Can i make a union of the sql generated by this report and another query(new query).

Thank you

 

[lbass]

Probably. You can create a union query by going to database->database expert->your datasource->add command and creating the union query there.

-LB

 

[synapsevampire]

LB's solution is based on having CR 9 or later, please take the time to at least post your Crystal version and the database being used.

You're probably better served to create a View on the database and create the UNION ALL. You can get the existing query using Database->Show SQL Query.

-k