PDF Rendering Problem - blank pages

I have a report that consists of a number of subreports. When I export to
PDF I get blank pages on every second page. No data is missing, it looks
like an incorrect margin setting or additional page break. If I export the
original "Sub"reports to PDF, then the problem does not occur.
I have checked the margins in the report and the subreports, and they are
all identical. Does anyone have any ideas I can try?
AndreCheck your master report.
Look at your report width as well as your left and right margins.
"Andre" <Andre@.discussions.microsoft.com> wrote in message
news:05B0EB7A-8DE7-4323-A4AF-383F4E4D8543@.microsoft.com...
>I have a report that consists of a number of subreports. When I export to
> PDF I get blank pages on every second page. No data is missing, it looks
> like an incorrect margin setting or additional page break. If I export
> the
> original "Sub"reports to PDF, then the problem does not occur.
> I have checked the margins in the report and the subreports, and they are
> all identical. Does anyone have any ideas I can try?
> Andresql

PDF files with images get unexpectedly large in SQL Server 2000 Reporting Services

When using quite small JPEGS (~ 800 KB) in a report the exported PDF is a few megabytes of size. Am I missing something (e.g. some kind of compression)?

Can anyone give me a hint on this one?

Thanks,
Neno

There is a known bug in 2000 (which I know wasn't fixed in the SP2 beta -- don't know about SP2 RTM, though) in the PDF renderer -- It causes images of any type to be converted to bitmaps, then rendered. I bet this is what you're running into.

|||

i want to download some programme so i need urgent thanks

|||

I would suggest installing RS SP2 and the latest QFE available (KB912424).

Thank you,

Nico

|||This problem still occurs in SQL Reporting 2005 localreports. An issue has been opened for this problem. Please add your vote. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=232211

PDF files with images get unexpectedly large in SQL Server 2000 Reporting Services

When using quite small JPEGS (~ 800 KB) in a report the exported PDF is a few megabytes of size. Am I missing something (e.g. some kind of compression)?

Can anyone give me a hint on this one?

Thanks,
Neno

There is a known bug in 2000 (which I know wasn't fixed in the SP2 beta -- don't know about SP2 RTM, though) in the PDF renderer -- It causes images of any type to be converted to bitmaps, then rendered. I bet this is what you're running into.

|||

i want to download some programme so i need urgent thanks

|||

I would suggest installing RS SP2 and the latest QFE available (KB912424).

Thank you,

Nico

|||This problem still occurs in SQL Reporting 2005 localreports. An issue has been opened for this problem. Please add your vote. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=232211sql

PDF files with images get unexpectedly large in SQL Server 2000 Reporting Services

When using quite small JPEGS (~ 800 KB) in a report the exported PDF is a few megabytes of size. Am I missing something (e.g. some kind of compression)?

Can anyone give me a hint on this one?

Thanks,
Neno

There is a known bug in 2000 (which I know wasn't fixed in the SP2 beta -- don't know about SP2 RTM, though) in the PDF renderer -- It causes images of any type to be converted to bitmaps, then rendered. I bet this is what you're running into.

|||

i want to download some programme so i need urgent thanks

|||

I would suggest installing RS SP2 and the latest QFE available (KB912424).

Thank you,

Nico

|||This problem still occurs in SQL Reporting 2005 localreports. An issue has been opened for this problem. Please add your vote. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=232211

Password for replication

I have a server that I will need to uninstall SQL Server and then install it again because of missing files.

I need to bring the back to the way it is or was. My problem is replication.
Since I am new one knows the Administrative Link password. When I try to generate script for replication for the password it uses the 'N'.

Is there a way to work around this problem? Please advise.

Thanks

LystraCan't you go into the distributor properties and set a new password?

-PatP|||But wouldn't I need to change it at 2 places?

If I do change it will it interupt anything?

Lystra|||If you are going to trash your existing server, you'll interrupt things a bit in the process. :) Changing the password will have little additional affect.

I'd take a systemic approach to your problem:

1) Declare downtime
2) Script, then remove replication completely
3) Detach all of the databases from the affected server
4) Rebuild the affected server
5) Reattach the databases to the affected server
6) Recreate replication from the script (this will reset the password to an empty string)
7) Collapse in a heap for about 16 hours or so

-PatP