Images in Reporting Services from database

I have a data table which contains a bmp image saved as a byte array. I am trying to have this image presented in a report, however, I get a red X after I follow the wizard.

I also tried it with the SQL Northwind database and I have the same issue. I am running SQL Reporting services 2005. Any suggestions on what could be going wrong?

Joe

after placing the image you have select the image source i.e. database in your case and then you have select the field name which contains image and the MIME type as image/bmp or try image/png.

this should work

|||

I have tried with both image/bmp and image/png on northwind DB as recommended. I still get red cross. Any ideal what's wrong?

|||

I have tried with both image/bmp and image/png on northwind DB as recommended. I still get red cross. Any idea what's wrong?

|||Please read this RS BOL topic: http://msdn2.microsoft.com/en-us/library/ms156342(SQL.90).aspx

Particularly read the comment near the top if the images came originally from an Access database, because in that case the actual image data is an OLE image and you have to write an expression to remove the OLE image header from the data. This also applies to the Northwind sample database.

Furthermore, I recommend to install SQL Server 2005 SP1 for Reporting Services.

-- Robert

sql

Images in Reporting Services from database

I have a data table which contains a bmp image saved as a byte array. I am trying to have this image presented in a report, however, I get a red X after I follow the wizard.

I also tried it with the SQL Northwind database and I have the same issue. I am running SQL Reporting services 2005. Any suggestions on what could be going wrong?

Joe

after placing the image you have select the image source i.e. database in your case and then you have select the field name which contains image and the MIME type as image/bmp or try image/png.

this should work

|||

I have tried with both image/bmp and image/png on northwind DB as recommended. I still get red cross. Any ideal what's wrong?

|||

I have tried with both image/bmp and image/png on northwind DB as recommended. I still get red cross. Any idea what's wrong?

|||Please read this RS BOL topic: http://msdn2.microsoft.com/en-us/library/ms156342(SQL.90).aspx

Particularly read the comment near the top if the images came originally from an Access database, because in that case the actual image data is an OLE image and you have to write an expression to remove the OLE image header from the data. This also applies to the Northwind sample database.

Furthermore, I recommend to install SQL Server 2005 SP1 for Reporting Services.

-- Robert

Images

I have a customer that has several thousand images (bmp) stored in a SQL 2000
database. Is there any way to copy the images programmatically to a folder so
they can be viewed using a photo program? Currently they use an Access form
to display the photos and, needless to say, I don't want to copy and paste
4,000 images.
"Paco" <paco6945@.yahooNoSpam.com> wrote in message
news:24B4FEEE-09C8-47E4-AD53-4F51F00DD284@.microsoft.com...
>I have a customer that has several thousand images (bmp) stored in a SQL
>2000
> database. Is there any way to copy the images programmatically to a folder
> so
> they can be viewed using a photo program? Currently they use an Access
> form
> to display the photos and, needless to say, I don't want to copy and paste
> 4,000 images.
>
It's straightforward to do this using a .NET program. When you select rows
from the table you can retrieve the image column as a byte array and save
each byte array to a file.
David

Images

I have a customer that has several thousand images (bmp) stored in a SQL 200
0
database. Is there any way to copy the images programmatically to a folder s
o
they can be viewed using a photo program? Currently they use an Access form
to display the photos and, needless to say, I don't want to copy and paste
4,000 images."Paco" <paco6945@.yahooNoSpam.com> wrote in message
news:24B4FEEE-09C8-47E4-AD53-4F51F00DD284@.microsoft.com...
>I have a customer that has several thousand images (bmp) stored in a SQL
>2000
> database. Is there any way to copy the images programmatically to a folder
> so
> they can be viewed using a photo program? Currently they use an Access
> form
> to display the photos and, needless to say, I don't want to copy and paste
> 4,000 images.
>
It's straightforward to do this using a .NET program. When you select rows
from the table you can retrieve the image column as a byte array and save
each byte array to a file.
Davidsql

Images

I have a customer that has several thousand images (bmp) stored in a SQL 2000
database. Is there any way to copy the images programmatically to a folder so
they can be viewed using a photo program? Currently they use an Access form
to display the photos and, needless to say, I don't want to copy and paste
4,000 images."Paco" <paco6945@.yahooNoSpam.com> wrote in message
news:24B4FEEE-09C8-47E4-AD53-4F51F00DD284@.microsoft.com...
>I have a customer that has several thousand images (bmp) stored in a SQL
>2000
> database. Is there any way to copy the images programmatically to a folder
> so
> they can be viewed using a photo program? Currently they use an Access
> form
> to display the photos and, needless to say, I don't want to copy and paste
> 4,000 images.
>
It's straightforward to do this using a .NET program. When you select rows
from the table you can retrieve the image column as a byte array and save
each byte array to a file.
David

Image .BMP only shows on first page, place holder on the rest

I am printing a batch of Explanation of Benefits and the image only shows on the first page for each person. If they have additional pages all I get is the little red X.
Thanks,
Phil

Bump - If I want an image on every page where do I put it.|||

This should work fine if you:

Put the image in the report header|||

As I had said in the initial post, the image is ther on page one but not on page two. Now the report may consist of 100 invoices. The ones with more detail that cause the individual report to go over spread over two or more pages do not display the image on page 2,3....

It is a page header and therefor print on ever page. It is not in the report header.

|||

I wasn't clear on that from the initial post. It really depends on the report layout. From what you say I'm assuming that you have a list control that's grouped by person with page break option checked. In addition to that some users data spans multiple pages. What's confusing is that you mention that you get a red X (image place holder) but no image. Where is the image placed? In the header, the body, a list control?

To my knowledge there are 2 things you can have repeated when paging:

The overall report header|||Why isn't the page header repeated on every page. Am I missing something in what I expect the definiton of a page header would be. The globabl function for printing page number ? knows that it is a new page. So why doesn't the image print on the second page. I eneded up telling the user SSRS wasn't cable of what we wanted and I removed the functionality for printing images based on a selection in a list box. Back to sw.writeline.|||

I'm afraid I'm still not clear on exactly what you are trying to do in the report and how it's set up. based on your comments i can only guess that you have a parameter who's value you are using to display an image. Is that correct?

You'll need to post some more details about the report setup.