summarizing several non sql tables on a single table

[CarolCook]

Hi:
I have 3 tables that I need to report on: a product table, a cost table with dates (purchases) and a revenue table with dates (sales). This report is in Crystal 10 using ODBC to grab non-SQL data. Is there any way to print a report which lists a summary by product with summarized costs and revenues (one line per product) without subreports and shared global variables?
Thanks,
Carol

 

[Turkbear]

Hi,
What non-sql datasource?

Can you join the tables..
Maybe Product --> Cost --> Revenues

Then you can group and summaraize as needed..





To Paraphrase:"The Help you get is proportional to the Help you give.."