Hiding watermark when printing/exporting to Excel

[jedoublefunk]

Using Crystal XI.

Does anyone know if there is a way to hide a watermark if the report is going to be printed or exported to Excel?

The watermark tends to muck things up when the report appears in Excel and I'm hoping I can suppress the section based on the print/export type.

I'm guessing it's a pipe dream, but it would be nice to confirm it.

Thanks.

 

[AndyMc]

jedoublefunk,

You could setup a string parameter {?export} with defaults of "No" & "Yes".

Set up a suppression formula on your watermark. Right Click it, format, common tab. On the x+2 formula button for Suppression enter:
{?export} = "Yes"

Andy