PDF Sizes

Hello,
I am using ReportViewer in a web application. When there is a chart as part
of a report and it is exported to PDF the file size is very large for a
single page; typically 10-12 Mb.
I am now supposed to manufacture a report that will be about 50 pages with a
large graph on each page and I don't thing a 500Mb file size is acceptable.
Isn't there a way for the charts to use a vector format instead or at least
a compressed format?
Thanks,
JohnHello John,
Thank you for using Microsoft MSDN newsgroup!
I understand that you'd like to know if charts in report could be
compressed or use a vector format when exporting to PDF. If I'm off-base,
please let me know.
This behavior is a limitation of the product and we have received similar
request from another customer. However, currently there is no option to
compress charts or use a vector format for charts as you want for local
report.
The major difference for PDF rendering for the local report is that PDF
doesn't support compression of data while rendering. So it will take long
time when compared to the one from the server PDF rendering. But this
limitation is only for PDF and for other rendering extensions like Excel
etc don't have difference in behavior from the local and the server reports.
Verifying with our Development Team, I found that resolution is also not a
configurable setting for the PDF renderer. The documentation link which I
sent earlier
incorrectly lists DpiX and DpiY as available Device Information settings
for PDF.
<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm
/rsp_prog_soapapi_dev_8bld.asp>
This documentation was corrected later for RS 2005 version:
<http://msdn2.microsoft.com/en-us/library/ms154682.aspx>
So unfortunately the DpiX and DpiY settings will have no effect when passed
to Render method.
Please rest assured your feedback on this is reported to the proper
channel. In the meantime, I also encourage you submit via the link below so
that product team could hear your sound directly:
http://lab.msdn.microsoft.com/productfeedback/default.aspx
You may want to consider using Excel rendering method but it may not meet
your requriment exactly. Or you may want to consider using a report server
to render the report for you other than using a local report.
If you have any questions or concerns on this, please feel free to let us
know.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.sql

PDF Rendering

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.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 Format Issues

My report was beautiful until I put groups around my two tables... actually
at first it looked fine... then I started changing text box sizes etc...
suddenly every second page in my report is blank... not in the viewer... when
I export to PDF... anyone know a RS exorcist?A bit silly to reply to my own post... but maybe someone else will run into
this problem... and it can be frustrating so here's how I fixed my problem...
1st off... a "page" in html isn't exactly the same size as a page in PDF...
a page in PDF has to be the same size as your paper... or less... I don't
know if html even has an exact page size limit... NEways...
The report designer in Visual Studio will increase your page size... if you
try to move a control outside of the space you have set... a pretty annoying
feature if you ask me... given that you usually want a page size to be
exactly the same forever... and sometimes you are playing with a long text
box, and you might not see the part off to the side increasing your page
width.
Does anyone know... is there a way to lock the page size?
"MER78" wrote:
> My report was beautiful until I put groups around my two tables... actually
> at first it looked fine... then I started changing text box sizes etc...
> suddenly every second page in my report is blank... not in the viewer... when
> I export to PDF... anyone know a RS exorcist?

PDF export results in extra pages.

I am experiencing some quirks when exporting to PDF.
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.