Crystal Reports Main report and 2 subreports

microsoft.public.dotnet.framework.adonet

12 May 2006 7:21 PM

Manz123

Hello All,
I have a main report created thru Crystal Report VS 2003.
This report gets its source from a Stored procedure with one parameter.

I have two other Subreports within the same report each of which gets
its data from it's own stored procedure with the same parameter.
I have linked the main report with the two subreports by specifying
that the parameters are the same. I have done that thru ...
"Edit..Subreport Links"
So 3 SP's each with one parameter. The parameter for all the reports is
the same.

While opening up the report from Dot Net Windows Application, I am
trying to find a way in which---

EITHER
I provide a dataset with the three datatables required for the main
report and 2 subreports

OR

I provide the main report with a dataset with just one table (for the
main report) and the report itself gets the information for the
subreports based on the "Subreport Links" that I defines earlier.

In both of the scenarios, the logon should be set automatically behind
the scenes

I would like to know which of the one is feasible/recommended method
and any pointers to the code would be highly appreciated.

Thanks a ton.