Viewing Data from two datasets in Report

Question

0.00/5 (No votes)

See more:

I have a report in Visual Basic 2010

I would like to view data based on two datatables from the same dataset. I manage to get data from one of the tables displayed in the report at runtime, but cannot see the other details from the other datatable.

Is there a way I can view the details.

I have placed the first table (MainData) in the header and the footer of the report

The DetailsTable I have placed data in the report detail section of the report.

When I run my program I get the Header and footer data displayed but not the details, I only see the column headings. Could someone help me out there.

Posted 24-Jul-11 12:24pm

SimbarasheM

Updated 24-Jul-11 13:27pm

Dave Kreskowiak

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2011-07-24T13:28:00

Solution 1

If you don't have a relationship between the two tables, I suspect your report design isn't going to show much at all.

Posted 24-Jul-11 13:28pm

Dave Kreskowiak

Comments

SimbarasheM 28-Jul-11 11:44am

Hi Dave

I have two queries defined in SQL Server and they are then refined i.e. I use parameterised queries in my Dataset in VB.Net.

I have defined the relationship on the two DataTables based on say invoice number field.

What I would like to view on my report is as follows:

1. Table A contains the data I would like to display in the Header section of my report

2. Table B contains the data I would like displayed in the details section when the report runs.

However when I run the report I only get values from Table A and just the column headings for the Details with no data displayed.

How do I ensure Table A is displayed and then also the results of Table B are displayed.

Thanks

Dave Kreskowiak 28-Jul-11 18:34pm

The reason why it doesn't work is because you don't have a relationship between the two tables. The DataTables need to be in a DataSet and have a DataRelation object added to the DataSet that describes the related fields. It's called Master/Detail.

SimbarasheM 31-Jul-11 7:56am

Hi Dave

Thanks for your responses I have found a solution available on this link http://www.codeproject.com/KB/reporting-services/1tomanyreports_vsnet2005.aspx

For anyone requiring the same results