Click here to Skip to main content
15,891,248 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Using SSRS , need to generate report, here i have two datasets one for main display & second dataset for displaying 2 sub categories of first datasets.

So the output will be, first dataset's each row may or may not contain its respective 2 sub categories[second dataset].

so here i need to display main row with its repective 2 sub catgories if present for that main row.

Any idea of how to display as Main dataset as Parent row with its repective 2 sub categories row next to it if present

two datasets used also is their possible to display with two tablix , one tablix present inside other or so

sample output :

1 , parent row1
Child 1
child 2
parent row2 ----- in case of no child , child 6, child 7 will not be displayed , only Parent row2 alone displayed
Child 6
child 7
parent row3
Child 3
child 4
Posted

1 solution

VB
http://social.msdn.microsoft.com/Forums/en-US/2dc48d60-76c6-4c27-8a96-e234fa4af5ef/is-it-possible-for-two-items-with-different-datasets-table-and-chart-to-render-together-on-same

http://msdn.microsoft.com/en-us/library/ee210531.aspx

http://msdn.microsoft.com/en-us/library/ee240819.aspx

http://www.sqlcircuit.com/2012/03/ssrs-2008-r2-lookup-how-to-use-multiple.html
 
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