Report with Watermark

[Guest]

Would greatly appreciate any help with this. I'm sure some Access guru has
seen this before.

I went to the report properties of my Access report and assigned a path to
the "Picture" property. It doesn't matter which predefined values you assign
to any of the other picture properties (such as the PictureType property).
The problem I am about to describe will occur with any picture property
settings.

The report previews/prints fine and displays the desired watermark after
assigning a value path\filename to the Picture property.

Immeditely after adding this report as a subreport into another report, the
watermark no longer displays. Is there a resolution for this behavior?

You can easily repro this in the Northwind sample database. Open the report
"Summary of Sales by Quarter" in design view and add the following to the
reports Picture property:

C:\WINDOWS\winnt256.bmp

I think this BMP file is available on most Windows XP machines. If not, just
select some other image on your system.

Close the report, saving the change, and then preview. The "watermark"
displays within the report.

Creating a new, blank report and drag/drop the report "Summary of Sales by
Quarter" into the Detail section of the new report.

Close the new report, saving with the name of Report1. Preview Report1 and
note that the watermark is no longer displayed.

How can I resolve this?

Adding the image to the main report is not an option in my case, as the
watermark will no longer properly align under the subreport.

Please help.
Thanks,
Joannie

 

[Guest]

I expect the picture property is tied to the subreport's "PAGE". Subreports
don't support anything that involves PAGEs.

A thought... You might be able to create a new primary sorting level in the
subreport and set its control source to a constant like:
=1
Display the header section of this group level and make it tall enough to
display your image. You can then add code to the On Format event of this
section:
Me.MoveLayout = False

Try it, no promises ;-)