May 7, 2014 at 9:24 am
In an SSRS 2008 r2 report I have 6 matrixes that I placed into 1 rectangle so that all the individual items do not float.
The problem is that the first page of the ssrs 2008 r2 report is blank when the report is executing.
I have set the report properties to: landscape, custom paper size, width 14" and height = 11". The report properties are width
14 inches and the height is 11 inches. The body properties keep changing to 26.75719 inches and width = 13.54667 inches.
If there is no property that can be set, then should I have more than one rectangle? To place the objects into separate
rectangles, I want to mention that that there is a header matrix and a summary rectangle that need to be shared. Matrix #2 and
Matrix #3 are for students in grades 01 to 08. Matrix #4 and #5 are for students in grades 09 to 12.
I have seen the following link: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/825fc82c-6259-4f59-a270-a96037a9026b/fit-all-rectangles-on-one-page?forum=visiogeneral. In here it says print scaling -> Page Setup -> Print Setup -> Fit to ..., however I do not see these options in ssrs. If that link is not referring to visio, how would I find these options in SSRS?
Can you tell me what I can do so that I do not have a blank first page when the SSRS 2008 R2 report is executing?
May 7, 2014 at 9:28 am
Is the rectangle at position (0,0) ?
May 7, 2014 at 10:56 am
Yes the rectangle was originally at Is the rectangle at position (0,0). I tried to change the location to (0.5, 0.5) and had the same problem. Thus I put the position back to (0,0).
Also:
When I set the border of the rectangle to solid, I can see the rectangle when the SSRS report is executing. The rectangle appears before any of the matrixes are displayed. However when I look at the rectangle in design mode, the rectangle is around all 6 of the matrixes.
Thus could you tell me why the rectangle is displayed in a different location when the report is executing and not around all the matrixes at that point?
April 11, 2019 at 12:15 pm
Hi,
Create a dummy rectangle before your first rectangle. In properties, Choose in Hidden parameter - True.
Goog Luck 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply