I want to hide a logo if the format of the report is Excel but display it when it is a PDF. When I set up conditional formatting xls is not an option for RunOption(). It works for CSV as that is an option.
Does anyone know how I would do this?
I actually did it with a statement on HTML/PDF (colours as well) since Excel doesn't import HTML colour codes very well).
Boolean Variable:
ReportOutput () in ('PDF', 'HTML')
When variable is NO:
Image Properties:
Box Type: None
Put ReportOutput() as a report calculation to find a value for each type of Excel outputs. They might vary. (and I'm to lazy to open the SDK book and look for it ... ;D )
Quote from: COGNOiSe administrator on 16 Jul 2007 07:38:37 PM
Put ReportOutput() as a report calculation to find a value for each type of Excel outputs. They might vary. (and I'm to lazy to open the SDK book and look for it ... ;D )
Is there a better motivation than sheer laziness? That's why I use the Boolean against the output being PDF or HTML. Any other output (any of the excel versions or csv) do not handle images well, so instead of trying to script a scenario for each, it just seemed easier to use a boolean on PDF|HTML.
Of course MDXpressor, but if Wildrose absolutely needs in Excel, that's the way to find out.
Lazyness is the Mother of Invention.