You’re offline. This is a read only version of the page.
To print Attachment image of fixed asset on report SSRS, have a display method here.
display Filename getImg()
{
DocuRef docuRef;
DocuValue DocuValue;
FileName fileName;
Image image;
container imageCont;
Bitmap ret;
;
select docuRef
join DocuValue
where DocuValue.RecId == docuRef.ValueRecId &&
docuRef.RefTableId == this.TableId && //fixed asset table id
docuRef.RefRecId == this.RecId && // fixed asset table recid
docuRef.TypeId == 'IMG';
return docuRef.completeFilename();
}
we must have a shared folder for it, we will give path of this folder to our expression img box and in system admin as well.
1. path of shared folder in System admin module.
2. Organization administration.
setup-->document management --> document management parameter.
3. Organization administration.
setup-->document management --> document type.
now after this, we call our display method in expression of ssrs.
="File:///" & Fields!getImg1.Value
if you read the code our display method return the full path of shared folder so here by that path we get file from that folder.
cheeeers !!!
*This post is locked for comments
You can look at any standard report and see how images are displayed . For example , salesInvoice report which shows company logo .
Hi
I don't think that's how you display an image like that in SSRS.
Please read this and correct your design/architecture accordingly
docs.microsoft.com/.../add-a-data-bound-image-report-builder-and-ssrs
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (