I'm using Crystal Reports in vs2008, so I'm using datasets with procedures to get the data from the db, my escenario is the following:
In the same Crystal Report, I have to show two reports, basically using the sames datasets, and the same database, but they are different queries (have grouping and summing instead)
Is this possible? And if it is how can I solute this, using database expert? or crosstab? What options of crystal reports supports these operations?
Best Answer
You should be able to insert a "sub report" in Crystal on your primary report. You can pass parameters from the main report to the sub report and utilize a whole different command in the sub report. I'm not sure the exact keyboard sequence to insert a sub report in VS2008, but in CR 2008, it's as simple as using the file menu INSERT > SUB REPORT.