Hi Alison,

 

Here’s how I add an object image thumbnail, to a SSRS report.

 

First, create this view in your db if it does not exist, already:

 

create view mainimage108 as select * from  mainimage where tableid = 108

 

Second, link the mainimage108 table to your report, e.g., from objects o inner join mainimage108 i on o.objectid = i.id.  In your select statement make sure the field ,mainimage108.thumbblob is included.

 

Third, in SSRS report, Click Insert > Image and click in cell.

 

 

The Image Properties box will appear.  Have your Image Properties equal this:

 

 

 

Finally, you can add the following to your select statement if you want to sort on the image field:  ,case when thumbblob is null then 0 else 1 end as hasthumb.  Let me know if you need info re: how to sort via Text Box Properties. 

 

 

From: Anderson, Alison M [log in to unmask]
Sent: Wednesday, September 29, 2021 1:24 PM
To: Morgan, Rob <[log in to unmask]>
Subject: RE: Image Pixelation in SSRS Report Exported to PDF

 

External Email - Exercise Caution

Hi Rob,

 

It looks like the screenshot below except I have “=First(Fields!Thumbblob.Value, "DataSet1")” in the expression for the “Use this field.”

 

I also thought about using the source image instead of the thumblob (in case it’s a compression issue, even though I also tried decreasing that in the Thumbnail creator in the Media Module), which we store on a hosted TMS server, but I can’t figure out how to get that to work either. When I try, a blank box appears in the Report Builder.

 

From what I read online, it might be an issue that no matter what you do, when it converts to PDF, it changes the dpi of all images to 96? But I’m not sure if that’s just conjecture-can’t trust anything on the internet!

 

Alison

 

From: Morgan, Rob <[log in to unmask]>
Sent: Wednesday, September 29, 2021 1:16 PM
To: Anderson, Alison M <[log in to unmask]>
Subject: RE: Image Pixelation in SSRS Report Exported to PDF

 

Hi Alison,

 

What does image properties look like in SSRS?

 

 

 

 

From: The Museum System (TMS) Users [log in to unmask] On Behalf Of Anderson, Alison M
Sent: Wednesday, September 29, 2021 11:34 AM
To: ListServ tmsusers <[log in to unmask]>
Subject: Image Pixelation in SSRS Report Exported to PDF

 

External Email - Exercise Caution

Hello,

 

Does anyone create reports with images using SSRS? Whenever I add a thumblob to a report and print to PDF, the image gets very pixelated. I am using a 300dpi JPEG. I’ve tried everything I can to make it clear and scoured the internet looking for a solution but have come up empty.

 

Thank you,

Alison

 

__________________________________

Alison Anderson, MSLIS, DAS, CA (she/her)

Senior Processing Archivist

Harvard Planning Office

Property Information Resource Center

1350 Massachusetts Avenue, Suite 585

Cambridge, MA 02138

T 617-495-4353  F 617-495-0559

www.planningoffice.harvard.edu/pirc

 

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.