If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Hide a Logo

Started by Wildrose, 13 Jul 2007 01:38:57 PM

Previous topic - Next topic

Wildrose

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?


MDXpressor

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
No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien

COGNOiSe administrator

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 )

MDXpressor

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.
No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien

COGNOiSe administrator

Of course MDXpressor, but if Wildrose absolutely needs in Excel, that's the way to find out.

Lazyness is the Mother of Invention.