SQL Reporting Service 2008 Printing Issues

apitech
apitech used Ask the Experts™
on
Hello:

On a SQL 2008\Windows Server 2008 (32-bit) box, I have a packing slip that I created in SQL Reporting Services with the Business Intelligence Development Studio.

When I print the report from the SQL 2008 Report Manager web page to Adobe PDF on the server, it prints satisfactorily.

But, when the end user prints to Adobe also from the Report Manager's web page on a Windows 7 workstation (32-bit), it "cuts off".  50% of the report (the right-hand side) does not print.

It is strange that it prints fine on the server and not the workstations.  Both are using the Report Manager internet.  So, I don't understand why the difference.

The issue is not an Adobe one.  This happens, also, if the report is printed to Microsoft Document Imaging also.

Too, if I make changes to the report in terms of margins or whatever on the Studio, those changes show up in Report Manager on the server.  But, those changes are not reflected on the workstation when printing from Report Manager.

Ideas?  Any help is very much appreciated!

Apitech
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
When you use the print button the settings on the workstation (paper size, orientation, margin etc.) determine the lay-out. Can't you use the save as pdf functionality instead. In the report manager click the floppy icon in the header of the report and select the PDF option. This way the pdf is rendered on the server and should produce the same result on every workstation.
check the print drivers on the work station. something is not working to PDF and Windows 7

Author

Commented:
Hello Guys:

Thanks, for the responses!

FYI--The issue is not just with Adobe PDF but with other apps such as Microsoft Document Imaging Writer as well.
 
Apitech
Why Diversity in Tech Matters

Kesha Williams, certified professional and software developer, explores the imbalance of diversity in the world of technology -- especially when it comes to hiring women. She showcases ways she's making a difference through the Colors of STEM program.

Before you print to the Microsoft Document Imaging Writer you can select the Preferences button. Here you can set additional printing options like paper size and orientation. Does it help when you change those settings?

Author

Commented:
Hi Nicobo:

Can those settings be changed immediately also when printing to Adobe PDF?

Apitech
When printing to a PDF printer, yes. When you use the save as option in the report, no.

Author

Commented:
By the way, the end user e-mailed me and told me that she did not see a floppy button in the Report Manager for her to save either the pdf or document imaging writer to a file.  So, we are back to troubleshooting the printing itself.

So, when she chooses to print--whether to Adobe or a printer or Microsoft Document Imaging Writer, can she change the settings in the window that pops up?
That's strange. Can you create a screencast/screenshot of the user opening the report and printing it, so we can see what exactly is going on. Be careful not to reveal any confidential data.

Author

Commented:
Hi Nicobo:

Actually, she sent me a screenshot.  There is no floppy icon.  But, there is the "Export" hyperlink which accomplishes the same thing.  Anyway, she still gets the same bad result.

I am having her check to see if changing the margin settings on the workstation just before printing does any good.  Will let you know.

Thanks!

Apitech

Author

Commented:
Hi Nicobo:

You were on the right track.  The bottom line is that apparently, because there are so many columns in my report, printing straight to the printer or to Adobe never produces good results--no matter what workstation we tried.

So, I went about to shrink columns and remove one or two columns in my report.  Most importantly, I found a way to "drag" the far right-hand edge of the report in the Business Intelligence Development Studio so that the size of the report would shrink.  That allowed us to be able to succcessfully export to Adobe and Word.  That sufficed

Now, there was one workstation that was still displaying the document "cut off".  So, we had to change margins and other settings on it.  Evidently, the export and print settings that I have been trying to combat, ultimately, are workstation specific.

Thanks, again!

Apitech

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial