Link to home
Start Free TrialLog in
Avatar of lamprianou
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(MyDataSet.Tables(0))
How do I pass two datasets in a Crystal report?

Thanks for your help
Jason
Avatar of razo
razo

u cant
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
Avatar of lamprianou

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
Avatar of razo
razo

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Are you trying to use dataset 1 for the main report and dataset 2 for the subreport all the time?
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