views:

1247

answers:

3

Hi Folks, im using Crystal Repots in vs2008, so im 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 diferents querys (have grouping and summing instead)

is this possible? and if it is how can i solute this, using database expert? or cross-tab? what option of crystal reports supports this operations?

Thanks in advance :)

+1  A: 

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.

GregD
im trying it now, thanks... maybe the query is so hardcode it expect grouping by columns that not exists in the database explicit, so here we go...
Angel Escobedo
+1  A: 
Spacehamster
A: 

I could not print the subreport created. Whenever I click the print button, it takes me to main report and export main report in a pdf instead of doing the same for subreport. Will you please let me know why it is happening so in Crystal Report 10.5 and Asp.Net (VS 2008). It works fine in VS 2005 (ASP.Net and Crystal Report 10.2)