Click here to Skip to main content
15,881,089 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
C#
I have an requirement which has multiple output using dataset in SSRS. I want to show first table first row in columnar(horizontal) and respectively I want to show its child(multiple transaction) records in the table within the same page.

The output which I was looking for something like below: 

Information
Provider : provider name
Last name : last name                    First name : first name
Number : number                          
Date of birth : 02/22/2016               Age : 20
Gender : m                               Description : description


Information 2 

<Table>
<tr><td> Code </td><td>Description</td></tr>
<tr><td> Code </td><td>Description</td></tr>
<tr><td> Code </td><td>Description</td></tr>
<tr><td> Code </td><td>Description</td></tr>
</table>


Information 3 

<Table>
<tr><td> Code2 </td><td>Description2</td></tr>
<tr><td> Code </td><td>Description</td></tr>
<tr><td> Code </td><td>Description</td></tr>
<tr><td> Code </td><td>Description</td></tr>
</table>



So far achieving columnar data on each page I have added list(primary dataset is provided) and inside the list I have added matrix and it was started working.

But when I add child transaction table inside this list, table is not accepting second dataset fields.

How I can achieve this requirement please guide me.

thanks in advance! Vijay


What I have tried:

I have tried using List control in Report builder but it is accepting single dataset and showing result in column manner.
But how I can achieve child data as I had mentioned in above for Information 2 and Information 3?
Posted
Updated 15-Mar-16 0:14am
v2

You cannot have multiple datasets in one table.

Instead of using multiple datasets you join the two and then group the results in SSRS.
the Following link should help you with this:
Lesson 6: Adding Grouping and Totals (Reporting Services)[^]
 
Share this answer
 
This part of issue is currently handled by bifurcating entire report into sub-report and breaking multiple dataset into a individual dataset at sub-report level and making an Identification column between the main report and sub-report. Hence I could have achieve this by doing so.

Thanks for help
Vijay
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900