Notifications
Clear all
Topic starter
I'm a software dev working for a VAR - we sell/support CPS 11 and 12.
Part of the value we add are custom reports.
I've got this request for a new report, and the "cleanest" way to do the SQL side would be having the query return several tables to the report. I can define in crystal reports how to link the tables together.
But I get "unknown errors" running the report in CPS when I add the second table to the SQL query. Is this even possible, or does all the data need to be mashed into one table to give to the Crystal Report?
If I take out the second table, everything works fine with just the first table. Looked through the SQL statements for all the stock CPS reports and I couldn't find any with more than 1 table returned...
Brian Nash
Posted : December 21, 2018 4:38 am
Hi,
You can certainly use more than one table. If you run the query in sql management studio or the equivalent oracle tool does it return the data you would expect?
Brad
Posted : December 26, 2018 12:55 am
A Crystal Report can access multiple tables. As a guess, perhaps the extra table is not correctly linked. What are you trying to do?
Posted : December 26, 2018 1:06 am
