Using images
-
what's the best way to store an image which appears on every report, e.g. company logo? if in a database, how exactly do you enter the image, or a pointer to the image, in a field? Alternatively how do you change the standard appearance of Report Manager, e.g. by adding your own logo?
-
found this article using c#
http://www.codeproject.com/cs/database/ImageSaveInDataBase.asp
-
One way I found that worked was to add the image file to the reports section of the project. IE Add Existing item change to all files and select image file.
The result of this is that when the reports are deployed to Reporting Services the image is also sent and available for the reports to use. Once the image file is in reporting services you may want to change it's properties to hide so that it is not visible to your users.
Hope this helps
-
I used a similar approach to that described in Bill Pearsons article (here) and use these templates almost every day.
re: the images, i stored them within the report as they're a reasonably small overhead (ie when streamed to text/binary and saved as part of the report xml), but I am also using small images
HTH,
Steve.
-
Just a quick note on his article, if you follow it to the letter. To save you pulling out lrge clumps of hair (as I did), if you have *any* intention of scheduling up the report, after creating it using your template *remove* the 'run by user ' (and the global User!UserID variable) as this will preclude you from setting this up as a scheduled report. Whilst this works a treat when running reports interactively, it doesn't work when trying to schedule reports.
Cheers,
Steve.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply