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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Howard Cantrell
check the print drivers on the work station. something is not working to PDF and Windows 7
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
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?
ASKER
Hi Nicobo:
Can those settings be changed immediately also when printing to Adobe PDF?
Apitech
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.
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?
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.
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
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
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
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