Images in Reports - Need improvement

[mmogul]

I am printing a variable logo in a report. The logo varies on the header of each page depending on the brand of the product.

I have created image frame which is in the group header for all the headings of the report. The path / file name are located in the query that is tied to the report. It is called by the onformat event on the group header: Me![ImageFrame].Picture = [LogoFile]


My problem is this:

1) Using this method has slowed down the report considerably. The images are about 30-40K. They are jpg files.

2) As each page is processed, I can see a flash on the screen that says "importing..." (or something like that). This flash will be disconcerting to the users.

I need suggestions on how to remove that flash and speed up the processing.

Thanks.

 

[JBinQLD]

If there aren't too many logos, then create a control for each, set visible to false and change your On Format logic to set the visible property of the appropriate on to true.

JB

 

[mmogul]

Thanks. But that is exactly what I had done prior to trying the above approach. Your approach has good performance. The only downside is that it does not allow for an easy addition of a new logo for a new brand. If that happens, I would like the user to be able to add a new record to a table with the location of the logo file. That doesn't work with your solution.