Solved

VB.NET and Crystal Reports with two datasets

Posted on 2004-10-03
5
510 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

740 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