Using Parameters with Crystal Repository Images 1

[jedownsjr]

Versions used: CR XI R2 and BOE XI R2.

I have images in the Crystal Repository, and I have added them to the Crystal reports so that when the reports run on schedule through BOEXIR2 the current versions of the images are used to create the new instances. This requires "hard coding" a new version of the same report just to select whichever image is needed (image for Client A vs. Client B). This results in multiple versions of the same report, the only difference being the image file selected from the Crystal Repository.

I am looking for some way to have the report check at runtime to see what value was entered for a parameter (or the value returned from a database field, etc.) to determine which image file from the Crystal Repository to use when rendering the report in BOE. (Ex.-if parameter is "ClientA" then image selected from the repository would be "clientA.jpg" ... if "ClientB" then "clientB.jpg" and so forth) So far, I cannot find any place to specify a variable to be used at runtime when selecting an image from the repository.

Question: Is it possible to use a parameter (or other method) to have a single Crystal Report reference the correct image file from the repository to display in the report?

 

[IanWaterman]

One solution is to place all the images on the report and then conditionally suppress based on client.

This could lead to a very large report though as Crystal tends to convert jpegs to Bit Maps when it renders them.

You will need to ensure that the jpegs are of the required size to optimise the size of the BitMap generated.

Ian

 

[jedownsjr]

Thanks for that suggestion. We have a high volume of reports, and need something like the Crystal Repository where you can update the image or text that lives in the repository 1x, then the change is reflected in all linked reports. This prevents having to modify each individual report, which can take a huge amount of time if you have a large report library.

Does any type of repository similar to this exist in SSRS?