Displaying different Logos on a report for each client

[Siggy19]

We have thousands of clients and want to be able to display each client's logo when they run the reports.

For example, for client A we want logo A, for client B we want logo B etc.

The only two ways I can think of to do this are;

1. Have multiple header sections and only display the relevent one, but this is totally impractical for 1,000s of clients.

2. Have the Logo passed as a BLOB from the database, but since this will happen on every row, and there could be 1,000s of rows, this will cripple the system.

3. Have a sub-report just showing the Logo, although I am not sure this would even work.

Any idea how I can dynamically select the logo from a directory on the network or from a BLOB table in the database without being a maintenance nightmare or destroying the performance of the system ?

We are using Crystal 10, with a SQL Server database using Stored Procedures.

Thanks,

 

[vidru]

An unlinked subreport is probably your best bet, but only if the images are in the database. Since you're using stored procedures, you could create a proc that returns the logo for the current client. Insert a subreport based on that proc, stick the image data onto the subreport, and put the subreport in the report header or footer.

If you're calling the reports from an application, you could pull in the image from the db or a directory, and set the image at runtime.

-dave