Sql Reporting Image

Gotcha. I'm going to test some of these features from VS2008 soon.
A good friend of mine at Microsoft may be able to help you with this right now however.
Use the contact page on Zain's site and tell him I sent you over.
http://blogs.msdn.com/zainnab/
Salute,
Mark

 

I was wondering if anyone has used images in sql reports.

I would like to have an image in the header but I can't embednorlink it anywhere.

Thoughts?

Thanks Alex.

 

Hi,
Here are a few methods for working with images in SSRS:


Add an image
http://technet.microsoft.com/en-us/library/ms156388.aspx

Add Project image:
http://technet.microsoft.com/en-us/library/ms159683.aspx


Background image:
http://technet.microsoft.com/en-us/library/ms155810.aspx

Embed an image into the report:
http://technet.microsoft.com/en-us/library/ms155899.aspx

 

Thanks but Im designing the report this with visual studio 2005.


I think I will need to install the business intellegence tool set from the sql server cd's.

 

Ok cool, thx Mark.

 

I should also say I don't wish to design the report via the Adhoc report designer using a model. It's to simplistic.

 

I noticed if you don't have business Intelligence Projects installed for VS2005 or 2008 and you use the built in report designer the image wizard does not show to allow you to embed an image even though you have the option on the properties page for the image control.


With business Intelligence Projects installed the image can be embedded via the wizard and the rdl file has a


<ImageData> tag in the xml with the image data.


It seems the only way to include an image with the report due to the amount of access discount ASP gives you with Sql report server, at our office we just upload the rdl and image files to the file server that is running Sql Reports, but I understand the security problems they have with exposing the report server.


Alex

 

I can't confirm anything yet but SQL Server 2008 may address that shortcoming.
All of my development time right now is being spent on SQL Server 2008, it's Oooooh so groovy.

Having started out with SQL Server 7 in the late 90's I've gone through the pains.
I'll keep ya posted.

BTw, here are some report links that may help:

 

SQL 2008, thats cool.


Our shop has just finished upgrading to 2005, can't say I like the management studio much, they removed some nice quick features that the old enterprise manager had even as buggy as it was. It seems I need to click twice as many times to create a view via designer or set permissions.


Anyway later.





Alex