Printing different report for different records

[gemadan96]

Ok. I've got that. I've setup a field for each image position in the diplomas table. I've copied one of the diploma reports and modified each image control. So where do I tell it that this is diplomaA or diplomaB so that the correct images display on the page?

[June7]

The image table has a record for each diploma? Each field has name of appropriate external image? Include the image table in report RecordSource by linking with Promotions on the common Diploma field. Now set the Image control ControlSource property with expression for image path. The image is just another kind of data. The ControlSource will dynamically change the display just like the student name changes in textbox bound to StudentName field.

[gemadan96]

I think this would work fine if I have just one image per diploma style. Right now one style has 6 images and the other has 8. If I link the image table, based on the sample data I get 136 pages of diplomas instead of 19. Additionally images that repeat for each style may appear in different locations. Another thought is that right now each of the diploma styles is for letter size paper. In the future there may be additional page sizes so I think I'm better off going with the method of having the user select the diploma style to print and have a separate report for each style. Unless you can think of a way to accomplish this. I also want the user to be able to change each of the different image instead of the entire background.

[June7]

My suggestion was for only one record for each diploma in the images table. This would mean a field for each image location on the diploma.

However, if you want to have different page sizes then does complicate and the solution you have is probably best.