March 29, 2011 at 10:57 am
Hello,
I'm hoping someone out there with more extensive knowledge than I can tell if what I am trying to accomplish is feasable.
I am using SSRS 2008. I am trying to create a report that will display graphs for each group member in the report. Let's say there are 12 groupings each with data. I would like the report to have 4 charts on the page so the report is a total of 3 pages (1 chart per group). So the first page would have charts for 1,2 on the top half of page, Groups 3,4 on the bottom, and so on.
Here is where I am having difficulty. If I set up a Row group, I can have two charts along the left side of the page with the right side blank. I fi set up a Column group, I have two charts along the top, with the bottom blank. If I add both a Row and Column group, I get a chart, then blank charts until the next group, then more blank charts until the group after that.
I know I'm not describing this well, but I know the Row/Column grouping is creating the space for these charts, but that's not what I want. I was thinking if there was a way to control the visibility based on the grouping, but while I couldn't get that to work, my assumption is that I would just have blank space and not an actual chart in it's place.
Thank you in advance for your assistance, and sorry if this isn't clear.
March 29, 2011 at 2:25 pm
I am not sure I understand what you are asking, but if I do, I would probably use a rectangle (not a tablix) and group it on a row. Then add your charts to the rectangle. The data in your charts will be constrained by the data in the row grouping of the rectangle.
March 29, 2011 at 3:31 pm
Daniel,
Thank you for your reply. I know I was having a hard time describing it in a way that made sense.
I know the tablix has a variable number of both rows and columns, while a table has a fixed number of columns and a variable number of rows. I guess I got so used to creating tablix reports, I completely forgot about using a table.
Based on your suggestion I created a table and grouped on rows and this appears to be what I am after. Need to work on it some more, but thank you very much!
Regards,
Jonathan
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply