June 5, 2012 at 2:31 pm
Okay, so I am have been banging my head against this for past 2 days but can't figure it out.
Currently, we have a report that's generated in a .NET application and then exported into excel. I need to replicate it in SSRS and export it.
I have attached the screen shot of the report. You can see that there is a group row, and when clicked on the '+' sign, it displays the detail. Problem is, that details need to be right underneath group row. I can't figure it out how to do this. Please Help. Screen shot of my failed attempt is also attached.
------------
🙂
June 6, 2012 at 11:20 am
Yeah, this is a bit tedious. You also want a separate header for your detail data. What you need to do is add a row at your group level. If the cells from your group and detail are in a 1 to 1 relationship (same number of columns) you add your detail header info to the textboxes here. If they are not the same number of columns then you need to merge the cells and then put individual textboxes in with your labels in the correct spot. Then in the row below that you merge add the data in the columns right below the appropriate textbox. If there are a different number of columns you might find it easer to merge (same as above) the cells and then put a tablix with the right number of columns into the merged cell. It might take some experimenting to get it the way you want.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply