web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Dynamic Image in Repor...
Microsoft Dynamics CRM (Archived)

Dynamic Image in Reporting

(0) ShareShare
ReportReport
Posted on by ChrisMavroudis 2,140

Hi,

I want to display an image dynamic based on a field value which is a link to the image.

I set the image source in SSRS as external but what syntax do i use to the "use this image" box ?

I try to use the field that has the link but is not working.

Thank you

*This post is locked for comments

I have the same question (0)
  • Aileen Gusni Profile Picture
    Aileen Gusni 44,524 on at

    Hi Chris,

    Check this link:

    www.sqljason.com/.../ssrs-reports-using-embedded-images.html

    Usually I use 'Embedded'

    Thanks.

  • ChrisMavroudis Profile Picture
    ChrisMavroudis 2,140 on at

    Hi Aileen,

    and what you do if you have 500 pictures ? or if is different for every client ?

    No this solution is not what I am asking.

  • Aileen Gusni Profile Picture
    Aileen Gusni 44,524 on at

    Chris,

    You didn't mention very clear in the beginning that I wanted to help you.

    How do I know that your dynamic image you are referring to is so many value and so on.

    You just mentioned about dynamic image based on the field value, how can I know you have how many field values?

    I though you just were referring to Option Set field Value.

    You can try using this URL:

    http://<SharePointservername>/<site>/Documents/images/image1.jpg.

    Which you need to construct the image1.jpg accordingly based on your field value.

    Source:

    technet.microsoft.com/.../ms156482%28v=sql.100%29.aspx

    In the External Image section.

    And I recommend you to store the URL so that you can use this as example

    =string.Format("{0}/Repository/{1}",Parameters!urlserverpath.Value,Fields!ImageNameURL.Value)

    or

    =string.Format("{0}/Repository/Images/{1}.jpg",Parameters!urlserverpath.Value,Fields!fieldvalue.Value)

    Make sure you have stored all the images in that repository/images folder.

    Hope this helps!

    Thanks.

  • ChrisMavroudis Profile Picture
    ChrisMavroudis 2,140 on at

    Hi Aileen, thank you for your efforts to help me. My bad i didnt explain .

    Neither the solutions you gave me are working, because in my database field i store the entire link . "myserver/.../image.jpg&quot;

    Neither when i use directly the value "=First(Fields!fieldname.Value, "DataSet1")"is not working .

    Neither when i use it like this " =string.Format("{0}",Parameters!Fields!fieldname.Value)"

    I am desperate , working on it all day :(

  • Aileen Gusni Profile Picture
    Aileen Gusni 44,524 on at

    =string.Format("http://{0}",First(Fields!fieldname.Value, "DataSet1)")

    Can it work?

    Make sure that if not dynamic, you can get the image first...

    Construct the textbox value first and then copy paste to the browser, if the browser even cannot get it, then there is useless try to find out the dynamic URL construction.

    THanks.

  • ChrisMavroudis Profile Picture
    ChrisMavroudis 2,140 on at

    I have the http:// also in the database field

    I have try the following also in a text box too

    In all the cases the text box it shows correct the link

    but the image doesn't show anything

    1)  =string.Format("{0}",First(Fields!new_imagelink.Value,  "DataSet1"))

    2)  =First(Fields!new_imagelink.Value, "DataSet1"))

    even

    3)  =string.Format("https: // multitank.cloudapp.net/tank_img/CC-440-RG.png")

  • Verified answer
    ChrisMavroudis Profile Picture
    ChrisMavroudis 2,140 on at

    I solved it .  For some reason , it could not display the image because it was in the same server. I hosted the photos in another server and now it works just fine

    Thank you all for your help

  • Raghav Chadha Profile Picture
    Raghav Chadha 106 on at

    hello Please help me regarding to display external image in SSRS report.It was happpening in Version CRM 8.2 but broken after 9.0,

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans