Wednesday, March 28, 2012
PDF Rendering
all my page sizes, margins etc. Ensured that my page size is minus my
margins etc. And still this is happening. Any insight would be lovely
thanks. Cannot deploy reports to customers application until this is sorted.Do you have a page break after any groups?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nat Johnson" <NatJohnson@.discussions.microsoft.com> wrote in message
news:60472AC6-90D7-4B80-84EA-C78ACFE98022@.microsoft.com...
> OK still having the problem of a blank page after every report. I have
> reset
> all my page sizes, margins etc. Ensured that my page size is minus my
> margins etc. And still this is happening. Any insight would be lovely
> thanks. Cannot deploy reports to customers application until this is
> sorted.|||No page break Brain. Managed to get it sorted yesterday afternoon with much
playing around with margins etc. Even are setting the page size to the
normal width less the margins didn't seem to help. I had to bring it in a
lot further.
"Brian Welcker [MSFT]" wrote:
> Do you have a page break after any groups?
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Nat Johnson" <NatJohnson@.discussions.microsoft.com> wrote in message
> news:60472AC6-90D7-4B80-84EA-C78ACFE98022@.microsoft.com...
> > OK still having the problem of a blank page after every report. I have
> > reset
> > all my page sizes, margins etc. Ensured that my page size is minus my
> > margins etc. And still this is happening. Any insight would be lovely
> > thanks. Cannot deploy reports to customers application until this is
> > sorted.
>
>|||What about the <Body> properties width and height. Do they conform to your
paper dimensions. And even if they do, is the 'can grow' option on in your
fields? Sometimes this can push your report past your defined margins and
create an extra page.
--
Message posted via http://www.sqlmonster.com|||I've had this problem a few times...make sure that your report width is small
enough to fit on one page. Try to keep it under 22.75cm wide. The extra page
is just the edges wrapping around to the next page.
"Nat Johnson" wrote:
> OK still having the problem of a blank page after every report. I have reset
> all my page sizes, margins etc. Ensured that my page size is minus my
> margins etc. And still this is happening. Any insight would be lovely
> thanks. Cannot deploy reports to customers application until this is sorted.
PDF Margins
pose the question without response. I am trying to output some reports
to PDF from the standard RS interface
(http://localserver/reports/....) The report generates a PDF
perfectly except that the margins are 1 inch on each side (I don't
know anyone that uses that setting), and can't seem to find a way to
set this at design time. I have set the page size to 8.5 / 11 and
placed everything appropriately on the design time grid. I am a
Reporting Services noob, but have written a number of applications
using various 4GL's (Delphi, VS, etc). This is my first experience
with anything .Net, so any specific guidance related to developing in
.Net should be included.Hi Kevin,
Thanks for your posting!
From your descriptions, I understood you could like to know how to set
Report Margins when rendering to PDF format. If I have misunderstood your
concern, please feel free to point it out.
Based on my knowledge, please try change the Left / Right / Top / Button
Margins number under
Report -> Report Properties -> Layout
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Monday, March 26, 2012
PDF export results in extra pages.
I have read all the other posts about page sizes, margins, etc and my situation seems to be a bit different.
PageWidth = 21cm
PageHeight = 29.7cm
Margins = 1cm
Body.Width = 19cm
I have a report that contains a bar chart (Height = 15cm, Width = 19cm) and below that a rectangle that contains two text boxes with totals information (Left = 11.6cm, Width = 7.4cm, Height 0.5cm)
Now most of the time it exports to PDF perfectly - all on one page as would be expected
If however the chart has more than say 20 items on the y-axis then the rectangle gets pushed onto an new page.
For extra information, but not to confuse the issue I also have a page header and footer that have items lined up right to the edge (left + width = 19cm) and they all display fine on the one page. It is just this rectangle that is having the problem.
When I move the rectangle to the left a bit (11.4cm) so 0.2cm away from the right hand edge then it works fine.
It is just very strange because I cant see how it is getting shifted only when the chart contains a lot of items.
Any ideas?
I finally found a solution that works for me, just after I posted - usually the way.
I have created a rectangle with left = 0cm and width = 19cm and then placed the text boxes
inside that rectangle, positioned where I need them.
Once I do that it renders onto one page.
What I think is going on here is a precision problem. I suspect that MS being a US based company their base units are the imperial system so Inches. So even though you can express your measurements in cm, pt's, etc - they are always converted to a base unit of inches. With any conversion process you can get problems with precision and that is what I think is happening here.
So I feel the best way to avoid these precision bugs is to adopt a report design strategy of not having floating report items in your report. Group items by placing them in a rectangle and set the left to 0 and the width to the exact page width boundary (in this case 19cm)
The other solution is to always use the same base units as the renderer (inches) that way you wont suffer conversion precision problems. Unfortunately for me it would take forever to convert all mine from cm to inches.