December 2, 2013 at 3:19 pm
I have scoured the 4 [million] corners of the interweb and found nothing that seems to address the very painful layout issue that I am dealing with. Essentially, I have to create a four-quadrant report with data from different tables (SP lists) in each square. I've tried dropping both tablix objects and subreports into the report. I've tried framing them in rectangles. I've tried framing the rectangles containing the report items in other rectangles, a la HTML nested divs. All to no avail.
All attempted solutions included two basic options for the size of the rectangles/subreports to the size of the data region:
1) Sizing the framing rectangle to fit the data region
2) Sizing the framing rectangle to be the desired size of the quadrant
The problem is that either the bottom row/quadrants move "up" if there isn't enough data in the upper row quadrants (option 1 above), or the whitespace between the data region and the container becomes padding that just pushes the quadrants down when multiple rows of data fill the data region. If this doesn't make sense, then you probably haven't dealt with the issue before.
Here's an idea of what a quad chart looks like:
http://www.goodmanson.com/wp-content/uploads/2011/10/QuadReport.png
Many thanks SQLServerCentral community!
December 3, 2013 at 11:36 am
Some immediate, untested, and possibly unhelpful thoughts:
1) Does the "Consume Container Whitespace" option help in not allowing the tablices to push down too far?
2) Can you put another white-space-only tablix below the upper quadrants that will be hidden if the size of the dataset above it exceeds a certain amount?
Question for you:
What exactly DO you want to have happen if one quadrant in your report "runs long"? Do you want the entire page to paginate, such that you would get a second page with four quadrants, one of which contains the additional run-over data? Or something else. I've never had call to build a non hard-coded report like this, so I don't know what the requirements would be.
Cheers,
EJM
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
