January 19, 2011 at 2:10 pm
Hello all,
Maybe I'm not doing something right here but I'm having a really hard time trying to arrange items onto a page within the margins. Is there a way to make the margins visible on the page so I can bump the content up against the inside of the margins? Otherwise I can't know where the margins are so that I get the content in the right place.
Any advice would be very helpful.
So you know, I'm very much a newbie with this. I'm building my first report.
Thanks
January 19, 2011 at 2:40 pm
This might not directly address your question, but I just show the ruler. You can find it in the menu -> Reports, Ruler.
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
January 19, 2011 at 4:26 pm
I'm using the Ruler but it's not helping me.
I currently have the following object sizes. This should all fit properly on a page. One problem I'm having now is that as soon as I make the left margin .5in I start seeing an extra blank page every other page in the report. I don't understand as even with the .5in left margin everything should still fit. Since I can't see where the margins are I can't fix this. The Tablix Size and Location gives me an extra inch on the left with the .5in margin and the right has an extra 3.5in.
Do I have to start removing PageSize from the report as I add Margin size?
Body:
Size: 8.5in x 11in
Report:
Margins: 0in, 0in, 0in, 0in
PageSize: 8.5in x 11in
Tablix:
Size: 6in x 5in
Location: .6in, .25in
January 19, 2011 at 5:01 pm
I found this article which may help me understand the problem.
January 19, 2011 at 5:34 pm
OK, now I understand that the Body is the area allocated for report elements, this includes the header and footer. The Report is equivalent to an actual page.
The Body has to be smaller then the Report PageSize including Margins. Once this sizing is done the contents can then be pushed up against the edges of the body (equivalent to outside edge of margin).
I'm starting to understand this.
New sizing.
Body:
Size: 7.5in x 10in
Should height be 8in to account for 1in header+footer or 10in as header+footer are already taken into account?
Report:
Margins: 0.5in, 0.5in, 0.5in, 0.5in
PageSize: 8.5in x 11in
Tablix:
Size: 7.5in x 6in
Location: 0.0in, 0.0in
Now I still have one problem which is that I always have a trailing blank page at the very end of the document. I also don't see this problem in the report. I have to export to Word and then I see the trailing blank page.
January 20, 2011 at 2:04 am
Hi Aaron,
Looking at the measurements it seems you have some white space at the bottom of your body/layout. It's better to never leave white space at the bottom or right as while the tablix is growing this white space could fall on the next page causing the empty pages you see. The whole body of your report gets printed including the white space.
Hope this helps.
Kind regards,
Linda
January 20, 2011 at 1:19 pm
I've changed the sizes to the following. The Tablix is now the same height as the Body to remove white space. This change did not fix the problem.
The report still shows the correct number of pages, without a trailing blank page. The exported Word doc still shows a trailing blank page at the end of the document.
Body:
Size: 7.5in x 10in
Should height be 8in to account for 1in header+footer or 10in as header+footer are already taken into account?
Report:
Margins: 0.5in, 0.5in, 0.5in, 0.5in
PageSize: 8.5in x 11in
Tablix:
Size: 7.5in x 10in
Location: 0.0in, 0.0in
January 21, 2011 at 1:29 am
Hi Aaron,
I'm afraid I'm out ot ideas. To be honest I'm not exporting to word all that often, but if the body of your report is exactly the same size as your tablix it sounds like a bug if you have an empty page printed.
I have seen that the border of the tablix falls on the next page. This could happen if your tablix grows in width or height but at least you should see something on this page... unless it is a bug.
Kind regards,
Linda
January 26, 2011 at 4:09 pm
Yikes, here we go again.
A different but probably related problem.
I'm now doing a report in landscape mode and have the following sizes setup.
Report:
Margins: 0.5in, 0.5in, 0.5in, 0.5in
PageSize: 11in x 8.5in
Body:
Size: 10in x 7.5in
Tablix:
Size: 10in x 7.5in
Location: 0.0in, 0.0in
Header:
Height: 0.5in
Footer:
Height: 0.5in
Now I get this message when trying to print from and Word export.
"The margins of section 1 are set outside the printable area of the page. Do you want to continue?"
January 26, 2011 at 4:14 pm
Maybe you've already tried this, but can you reduce all of your report margins to .30 to see if that resolves it?
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
January 26, 2011 at 4:21 pm
Some how I'm also getting a trailing blank page. I did forget to mention that I have the report setup for landscape, hence the wider then taller page layout.
So I have tried reducing the marging to 0.3 and also to 0. No change.
I have also tried making the Body and Tablix smaller, down to 9in x 7in, and I still have the trailing blank page and the margin error message.
It seems to me like my sizes are all correct. I don't know what else to do. I don't have much added to the report and I'm considering deleting it and starting over. I don't know if that will help or not.
January 26, 2011 at 4:31 pm
Hmm... I've had issues like that too with SSRS and I wish I could remember what I did to resolve them. I do remember a lot of trial and error :hehe:. Shrinking the report's data until it works like it should comes to mind, but I believe that I'm being too simplistic (again).
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
January 26, 2011 at 4:32 pm
Another test, I've removed the header and footer. This solved the problem of the trailing blank page. So why can't I use a header and footer?
I also am still getting the margin error when trying to print from the Word export.
January 26, 2011 at 4:52 pm
Something else, even though I have the report all setup for landscape and the Word export is also landscape, the print options default to portrait. Even if I change the print options to landscape it still prints in portrait. This may be why I'm getting the margin error in Word. Even though everything is set for landscape Word is still printing portrait so it's giving me a margin error, which would make sense.
What's going on here?
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply