lamprianou
asked on
VB.NET and Crystal Reports with two datasets
Hi
I use Crystal Reports to show summaries of my data from an ACCESS database. In one case, I want to have two datasets from which to draw data for my report (the second dataset is for a SUBreport). I know how to attach ONE dataset on a Crystal Report, I am using the following:
oRpt.SetDataSource(MyDataS et.Tables( 0))
How do I pass two datasets in a Crystal report?
Thanks for your help
Jason
I use Crystal Reports to show summaries of my data from an ACCESS database. In one case, I want to have two datasets from which to draw data for my report (the second dataset is for a SUBreport). I know how to attach ONE dataset on a Crystal Report, I am using the following:
oRpt.SetDataSource(MyDataS
How do I pass two datasets in a Crystal report?
Thanks for your help
Jason
ASKER
Can you please be more specific? Give an example or something like that? How can I define which table each report/subreport uses?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you trying to use dataset 1 for the main report and dataset 2 for the subreport all the time?
ASKER
OK razo,
give me a couple of days to try to use the solution you suggest and I'll come back to you.
Yes RacinRan, I am always using dataset 1 for the main report and dataset 2 for the subreport. Any good ideas?
Jason
give me a couple of days to try to use the solution you suggest and I'll come back to you.
Yes RacinRan, I am always using dataset 1 for the main report and dataset 2 for the subreport. Any good ideas?
Jason
what u can u do is use one dataset that include all the tables of both datasets and then in each report define the tables that are needed for the report