November 7, 2011 at 4:12 am
[font="Tahoma"]
Hello Friends,
I am new to SSRS and I am trying to learn from some already existing exercises from WROX book for SSRS. However, I am unable to create a similar RDL from the exercise. I have attached the screenshot of the Tablix for the RDL. PLease let me know the steps to create the ROw Groups as present in the screenshot.
Or kindly let me know any websites which has any information on this.
[/font]
November 7, 2011 at 5:56 am
Here's how:
1) You create a table with nothing in it. You drag Color and StandardCost to the two columns on the right, which leaves you with one empty column at the left. In this empty column, you drag the ProductName. These are the detail rows.
2) In the row groups, you click the arrow for the detail rows, select Add Group and choose Parent Group. In the pop-up menu, select ProductSubcategoryName, but do not create any header or footer. Click OK. You know have an extra column with the ProductSubcategoryName before the ProductName. Right-click on the cell of this column, select Insert Row in the context menu and choose Inside Group - Above. Now you have a row above your details row, but nothing in it. Assign the ProductSubcategoryName field to the empty cell above ProductName. Now delete the leftmost column. This will give you a grouping of productname on ProductSubcategoryName in the same column.
3). Repeat step 2, to group ProductSubcategoryName by ProductCategoryName in the same column.
Now you have the grouping that you want, you just need to apply layouting and add indentation to the specific rows.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 7, 2011 at 10:56 pm
[font="Tahoma"]
Thanks Koen.. It worked exactly the way that i was looking for.. Thanks for your help.. I was trying my best without any help, but could not find the way to do it.. Thanks for the details steps...I appreciate that.
Cheers mate...
[/font]
November 7, 2011 at 11:50 pm
MuraliKrishnan1980 (11/7/2011)
[font="Tahoma"]Thanks Koen.. It worked exactly the way that i was looking for.. Thanks for your help.. I was trying my best without any help, but could not find the way to do it.. Thanks for the details steps...I appreciate that.
Cheers mate...
[/font]
No problem, glad to help.
I encountered this issue myself when I was learning SSRS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply