All, I have a following kind of thing to show on my report in ssrs 2008 R2. For ex, my dataset fields are:- PCR, IR, and a table(with some other field) that should be associated to IR. (whereas, you can consider this as a hierarchy structure, i.e. PCR is at the top most level of hierarchy and then IR comes underneath PCR) I want to show on my report:- PCR 1 --> IR1 and a table associated to that IR1 --> IR2 and a table associated to that IR2 --> IR3 and a table associated to that IR3 and so on... once, PCR1 completes with its all children IR then comes PCR2... PCR 2 --> IR1 and a table associated to that IR1 --> IR2 and a table associated to that IR2 --> IR3 and a table associated to that IR3 and so on... Basically, it is like having ForEachLoopContainer within SSIS (just to co-relate it to make more understandable). So, each time user selects parameter at run-time at the initial screen of report, based on that parameter it should display associated PCR and IR. What I am doing as of now is, I have put one "List" control in which I have PCR and IR datafields and then I have put on "Table" which has fields associated to that IR. But since it is a "List" it is displaying like below to me, which is not correct format:- PCR: abc IR: xyz PCR: abc IR: xyz PCR: abc IR: xyz and so on...

any idea on this?

Denormalize a dataset for your report, for example PR1, IR1, col1, col2, col3 ... PR1, IR2, col1, col2, col3 ... PR2, IR1, col1, col2, col3 Use a tablix control and add 2 groups (2 headers): PCR and IR sorted by PR and IR (you could add additional integer columns for PR and IR if needed). In the first header display PR and in the second header display IR. Add col1, col2, col3 in the detail sections Sergei

Hi Sergei, I cannot denormalize dataset as you are saying because in dataset there is only one field for PCR, one field for IR and some other fields; using which only I have to create report like this... so ideally my report should look something like this:- PCR: PCR_Name1 IR: IR_Name1 IR Duration for this IR_Name1: [StartDate+EndDate] And a table with some other fields(for ex, Expenditure_amt, Commitment_amt etc.) for this IR_Name1 --------------------------------------- PCR: PCR_Name1 IR: IR_Name2 IR Duration for this IR_Name2: [StartDate+EndDate] And a table with some other fields(for ex, Expenditure_amt, Commitment_amt etc.) for this IR_Name2 ......and so on.... ------------------------------------once all IR completes for this PCR_Name1 then comes PCR_Name2 PCR: PCR_Name2 IR: IR_Name1 IR Duration for this IR_Name1: [StartDate+EndDate] And a table with some other fields(for ex, Expenditure_amt, Commitment_amt etc.) for this IR_Name1 ----------------------------------- PCR: PCR_Name2 IR: IR_Name2 IR Duration for this IR_Name2: [StartDate+EndDate] And a table with some other fields(for ex, Expenditure_amt, Commitment_amt etc.) for this IR_Name2 ......ans so on.... Hope, the sturcture is clear now..."Tablix" control above should be displayed for each IR. Do we have anything like "container" in SSRS in which we can put it so it repeats accoringly based on the parameter user selects? Thanks,

Hi Tej-BI, To your requirement, I think you should drag a table control on the report, type in the IR Duration expression for the textbox, then drag other datafeileds to the table, then add two parent groups IR and PCR, make sure the sequence is IR PCR not PCR IR, the add a list control grouped by PCR, then you will get the layout of your report. Thanks, Challen Fu

Hi Tej-BI, To your requirement, I think you should drag a table control on the report, type in the IR Duration expression for the textbox, then drag other datafeileds to the table, then add two parent groups PCR and IR, make sure the sequence is PCR IR not IR PCR, the add a list control grouped by IR, then you will get the layout of your report. Thanks, Challen Fu

Hi Challen, Two points here based on your feedback:- 1) Adding a table to this layout is seperate thing (i.e. at the end, once PCR and corresponding IR1 completes) and table should not contain any of this field i.e. PCR, IR, Duration etc. as it is seperate control with some other fields as I mentioned in last post it has some fields like expenditure_amt, commitment_amt etc. 2) I understand, adding two parent groups(PCR and IR) here is the key. But when you say, "then add a list control grouped by PCR"???? I did not understand that thing.

Hi Tej-BI, Of course, you could only display some datafields such as expenditure_amt, commitment_amt etc except PCR, IR, Duration. PCR, IR is just the group datafield. To your second question, it might be the key point of your issue, you should give a group to the list control, this group's datafeild is just IR(I am sorry type the wrong word in my last reply, it should be IR not PCR, hope you could notice this point) Steps for adding a list group are below: 1. Select the list control, and then right-click the (Details) on the Row Groups pane->select Group properties. 2. Click Add button. 3. Select a group datafield(IR) in the drop-down list If you have any question, please feel free to ask. Thanks, Challen Fu