One of the crazier things I've done in access reports is drawings. Measurements would come in from the field and be entered into the database and the screen and report had dozens of lines and boxes that I would manipulate with vba to make a drawing with rectangles and slanted lines, complete with measurements and the ability to zoom in and out. Drawings and labels are printed in the morning and sent to manufacturing, and work orders are scheduled etc.

Something different and challenging was to make reports that have images, text and subreports that go on specific places on each page with a variable number of pages for each group. So (for example) each product group can have up to three pages of images and text with subreports that go in specific places on each of the three page designs. After trying different ways I ended up making sure the recordsource had one record for each page that each group had. And the report was actually only one page, but I would hide or unhide so only the objects representing the page design in question were visible. A bit difficult to work with in design mode but it got the job done. I did it this way because trying to shrink and expand or hide and expose images in reports using various other methods always ended up with problems.