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.
[cid:image002.png@01D7B536.A5CAED00]
The Image Properties box will appear. Have your Image Properties equal this:
[cid:image001.png@01D7B535.C6A698E0]
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.
* Rob Morgan (Smithsonian)
From: Anderson, Alison M [log in to unmask]<mailto:[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]<mailto:[log in to unmask]>>
Sent: Wednesday, September 29, 2021 1:16 PM
To: Anderson, Alison M <[log in to unmask]<mailto:[log in to unmask]>>
Subject: RE: Image Pixelation in SSRS Report Exported to PDF
Hi Alison,
What does image properties look like in SSRS?
* Rob Morgan (Smithsonian)
[cid:image001.png@01D7B535.C6A698E0]
From: The Museum System (TMS) Users [log in to unmask]<mailto:[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]<mailto:[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 <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.proofpoint.com%2Fv2%2Furl%3Fu%3Dhttps-3A__nam02.safelinks.protection.outlook.com_-3Furl-3Dhttp-253A-252F-252Fwww.planningoffice.harvard.edu-252Fpirc-26data-3D04-257C01-257CMorganR-2540si.edu-257C10585e3f4bdb424fec5608d9835f5976-257C989b5e2a14e44efe93b78cdd5fc5d11c-257C0-257C0-257C637685267817387175-257CUnknown-257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0-253D-257C2000-26sdata-3D8HV85EqXVmJQNcjmQxgUat4hVrJrxT-252BKZWpEhVVAY18-253D-26reserved-3D0%26d%3DDwMFAg%26c%3DWO-RGvefibhHBZq3fL85hQ%26r%3DquoOUJsFLp9QkV73zKzlY2xi3Ttim3mc0ZY4uDpkyV0%26m%3DM5Di1-odUfg3Mt-B8lfirwRRDXaW7WstHUas8dCXUmQ%26s%3D6Ebf17WYOZ9EP5OJoHxkRlXnH6B29m8Bcgxy3FwQ-iM%26e%3D&data=04%7C01%7CMorganR%40si.edu%7C8f4dafe4fbdc4b3f70d508d9836de219%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637685330238678525%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=VdHhybpJ03DLhFTXt4r5Itcjj5rbbSLfMI5U%2F8%2FMH9Y%3D&reserved=0>
To unsubscribe, send an email to [log in to unmask]<mailto:[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.