Solved

VB.NET and Crystal Reports with two datasets

Posted on 2004-10-03
5
512 Views
Last Modified: 2006-11-17
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
Comment
Question by:lamprianou
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 8

Expert Comment

by:razo
ID: 12214942
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
 

Author Comment

by:lamprianou
ID: 12215237
Can you please be more specific? Give an example or something like that? How can I define which table each report/subreport uses?
0
 
LVL 8

Accepted Solution

by:
razo earned 35 total points
ID: 12215405
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
 
LVL 3

Expert Comment

by:RacinRan
ID: 12216707
Are you trying to use dataset 1 for the main report and dataset 2 for the subreport all the time?
0
 

Author Comment

by:lamprianou
ID: 12219803
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question