Hi,
In a report which I want to burst, I have a "dynamic logo" (i.e. a logo which change depending on which company you've selected in the prompt).
The "dynamic logo" is made with Conditional Explorer, where each company has been given the value 1, 2 or 3.
In Properties (Image) I've made a link (URL) to the logo of each company (company 1 = 1.jpg, company2 = 2.jpg and company3 = 3.jpg).
That's more or less it...
The problem is that the logo won't show when I burst the report. I know that there are some problems bursting crosstabs and graphs (and I know the solution is to put crosstabs and graphs in lists and then make a Master Detail Relationship), but I don't know what to do with images with Conditional Explorer "attached". For instance there's no query to the images so I can't make a Master Detail Relationship to a list.
Any idea?
Best regards,
Jacob
Try this.
This is what I do and it works for me.
After you put Image from Toolbox in a table, in properties --> URL Source --> Source Type: Report Expression.
Report expression:
Case
when [Company] contains 'company1' then www.example.com/company1.jpg
when [Company] contains 'company2' then www.example.com/company2.jpg
else example.com/company3.jpg
end.
Let me know if it works.
Hi,
Thanks for your answer. It might very well work, but the thing is that I have many reports where I have made this solution with Conditional Explorer and I would be a little reluctant to begin modifying them...
Feel free to suggest other solutions :)
/Jacob