Changing Image in report header based on parameter value
Posted on 2016-08-26
Using Crystal Reports IX
I have developed reports where there is a department logo image currently embedded in each report header. I would like to be able to dynamically change the department logo based on a value the user enters which corresponds to the AgencyID. Currently I either completely remove the logo image or painstakingly replace the image with another for each department.
All departments use a version of MS SQL Server. Some locations there may only be "One" department in the database so the default agency value is "1". Other locations there can be multiple departments with a corresponding AgencyID.
Single Agency Database
Multiple Agency Database
Can I link to a specific image? Example: \\Image\departmentlogo1.jpg
Or do I need to store the image into the database?