Use a conditional formula to dynamically change the location of a report’s image.
- Add an image to the report (Insert | Picture). This image will act as a placeholder. Ensure that the placeholder is the same size as the one that will be dynamically loaded, otherwise the image will be scaled.
- Change the image’s Graphic Location:
- right click image
- select Format Graphic…
- select Picture tab
- click the conditional-formula button (looks like x+2)
- set the formula’s text to the name of the formula or parameter field that will contain the image’s URL
- save the formula and click the OK button
- Save the report
Hi,
I found your website from the answer submitted by you for question “Convertion of crystal reports to SSRS Report” in Stackoverflow.com.
I am looking for a option to develop a tool in VB.NET which would convert Crystal report object model to SSRS RDL model.
Hope you would help me in doing this. If you are interested in developing this, please let me know.
Best Regards
Gowtham
I am working on Visual Studio 2008 and My Crystal Report(10.5) Designer toolbox controls does not contain any control that serve as Image placeholder, instead if I use a picture control, it adds the image statically as an OLE control and does not allow me to change the URL dynamically.
please guide.
Hi
The sample report for dynamic graphic doesnt work for me. (Crystal XI R2). A file from the web site http://www.cogniza.com is not displayed. If I pull the dynamic path from my c drive then that works fine. I read something about Crystal not sypporting dynamic web images accessed thru a proxy. Is that correct ?
Worked like a charm!
Thanks for posting this.
Hi,
Its good and helping post. But In one scenarion I am setting one selection parameter in my app code and passing that parameter to main report.I am using one sub report to show some images of the same parameter(which I sent from App code).I have linked my subreport and main report properly and then applied your approach in my subreport.It displays all images dynamically for that parameter except first one.In place of first image it is showing the placeholder image(which I have inserted as step 1st).Any help will higly appreciated.Thanks Pradeep
Hello,
I have same issue as Azfar Khan. I’m working with VS2005 and crystal report version 10.2.3600.0. I add a picture Insert > Picture. When I right-click on that picture, there’s no formula button in picture tab.
Is this because of crystal report version? How can I load picture dynamically without using dataset and datatable? Pls kindly advice.
Regards
My crystal report ignores the value specified in the formula and simply shows the original image no matter how hard I try. What could be the problem? Even your example which I downloaded behaves the same way.
I got this site from my buddy who told me concerning this web site and at the moment this time I am visiting this website and reading
very informative content at this place.