Details rows inside tablix SSRS Reporting service, Records with Details rows under it

1
votes

Now it is a report with a tablix in which the records are like
every row has some details rows under it.
and the details row can have one or more records based on the main tablix rows

To elucidate the problem, plz have a look
enter image description here

Did some search here and there, but not able to figure out how to accomplish this.
Sub-reports inside the tablix cell, but how will it keep the track of the current row

One thing more : Do I need to create two separate datasets for this and bind accordingly or write query as a single dataset and do some grouping ?

any ideas !

P.S: SSRS r2 environment, native mode reports for web application

2
sql-server-2008-r2reportingreporting-servicesssrs-2008-r2
Hiten004's answer is the one I'd go with. To add a subreport just right click the cell and select Insert > Subreport. Then you can right click it and select subreport properties to customize according to your needs. – eestein
@eestein yes it is solved now! but I wonder where did my image go, after questions are answered..I dont think that the images are removed ..?? – Irf
You are probably using some sort of firewall/proxy that's blocking the image. Here I can see it fine. – eestein

2 Answers

3
votes

create report with subreport will solve your problem

  1. you can create one report with one dataset with (BIL NoB NoW Est TotalXYZ) columns.
  2. Now link that subreport with the BIL
  3. Now link subreport with main report the BIL (FK)

Hope this help

4
votes

You can achieve this with one Dataset and one Tablix.

The Dataset will have all the columns in the report, with multiple rows for each BIL value.

The Tablix will have four rows and one group based on BIL.

The first row will be the Tablix header row, with the main column header details.

The next two rows will be group header rows. The first row will contain the group details, BIL, No Bayar, etc. The second row will contain the detail row header details.

The last row will be the detail row which will contain the COL1 and COL2 detail values.

You will see something like this (you'll need to fill in the TextBox details as appropriate):

enter image description here