PDF Caching Problems

Question

PDF Caching Problems

Viewing 6 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

jcraddock Default port Points: 1498 More actions · Answer 1

I've just started testing with it and haven't noticed that problem yet, but my PDFS are all one full page, one blank page, one full page, one blank page...

Have you seen that?

Rayven SSCarpal Tunnel Points: 4337 More actions · Answer 2

The problem of blank pages is down to layout. this took me some time to work out myself. The report is somehow going beyond the width of an A4 page, even though it doesn't appear to do so on the design form. Watch your page margins, positions and widths of fields. I had to drag all the fields to the left and shrink them down until the problem went away, and then slowly move and grow them back until it re-appeared, then knock them back one step again.

Time consuming I know, and infuriating on complex reports.

---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.

jcraddock Default port Points: 1498 More actions · Answer 3

Thanks for the reply. I will give that a shot. I wonder if they are planning on fixing it. That is going to be a huge nightmare.

Jack Corbett SSC Guru Points: 184395 More actions · Answer 4

Rayven, are you going through any kind of Proxy server that may be caching the PDF?

I had the other problem with blank pages sort of. I had 3 subreports on a report, each set to start with a new page. The first one came out fine, then I got the second subreport, then I got the page header for the second subreport on its own page AFTER the data, and the 3rd subreport was fine. I probably should have used data regions, but the users may wan tot see each one of the 3 reports stand alone so I did it with subreports. As Rayven said I played with sizing and page breaks until it looked right.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Jack Corbett SSC Guru Points: 184395 More actions · Answer 5

This is in addition to my last post. I participated in a Web seminar on RS by SQL Server Magazine last week and they demonstarted creating a standard report template that you then could use to give all your reports a consistent look, including header, footer, and margins. All you do is create a report without a data source and set up margins and whatever you always include (logo's, etcc..). Save the report and copy it to C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer\ProjectItems\ReportProject. This may help for the dat, blank, data problem

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Rayven SSCarpal Tunnel Points: 4337 More actions · Answer 6

Many thanks for pointing out the obvious that I'd overlooked!

I do this with Visual Basic, creating and templating forms, so why on earth I never thought of doing it for the reports I'll never know.

Many thanks.

---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.