February 5, 2007 at 10:55 am
Hi All
I'm using SQL Server Reporting Services 2005 and having a few problems with external images.
My report server is on server A and my image library is on server B. Both servers are in the same domain. The image URLs are supplied though a database field. I use this database field name in the code as follows:
Image Name="Photo"
Source:External
Value:=Fields!Photofile.Value
(sorry I couldn't get the tags to show properly in my post but they are in the report)
Problem 1:
The reports render quite quickly through the browser window. Printing, however, is incredibly slow. The images are small, typically 50K.
Problem 2:
If I try to export to pdf in report manager, I very often get the runtime error 'Non-negative number required. Paramerter name: value.
I'm fairly new to reporting services so any advice would be much appreciated.
February 8, 2007 at 8:00 am
This was removed by the editor as SPAM
February 14, 2007 at 7:37 am
I investigated this further and found that the error message appears when the image url picked up from the database field did not point to an existing image. I reworked my database to point to a standard 'image not avaiable' image for records without an image.
The printing performance for reports with external images is still an issue. If I export to pdf then print, it's fine. Printing direct using the Report Manager through IE6 can take 3 minutes for a report that produces a 20Mb spool file. Is there someting inefficient in the way RS prints images?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply