[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 520
  • Last Modified:

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
0
lamprianou
Asked:
lamprianou
  • 2
  • 2
1 Solution
 
razoCommented:
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
0
 
lamprianouAuthor Commented:
Can you please be more specific? Give an example or something like that? How can I define which table each report/subreport uses?
0
 
razoCommented:
i mean u can put all the tables in the dataset
then when u r creating the report and using the wizard u can choose this dataset and pick up the tables related to the report
u can do the same when creating the sub report
0
 
RacinRanCommented:
Are you trying to use dataset 1 for the main report and dataset 2 for the subreport all the time?
0
 
lamprianouAuthor Commented:
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
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now