Link to home
Create AccountLog in
Avatar of apitech
apitech

asked on

SQL Reporting Service 2008 Printing Issues

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
ASKER CERTIFIED SOLUTION
Avatar of Nico Bontenbal
Nico Bontenbal
Flag of Netherlands image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
check the print drivers on the work station. something is not working to PDF and Windows 7
Avatar of apitech
apitech

ASKER

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
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?
Avatar of apitech

ASKER

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.
Avatar of apitech

ASKER

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.
Avatar of apitech

ASKER

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
Avatar of apitech

ASKER

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