Print Page - Condition Explorer to show block for only EXCEL Report (Rep. Auth. 10.2.1)

Title: Condition Explorer to show block for only EXCEL Report (Rep. Auth. 10.2.1)
Post by: gosoccer on 17 Jul 2015 05:55:10 AM

Well, I thought I had it running. :-\

The following works well on a Block for PDF but for EXCEL, it is not.

IF  (ReportOutput() in ('PDF','XLS','CVS'))
THEN ('Y')
ELSE ('N')

Please help if you can. :) :o

Thx so much!!

Title: RESOLVED: Condition Explorer to show block for only EXCEL Report (10.2.1)
Post by: gosoccer on 17 Jul 2015 06:06:31 AM

Resolved:
I added additional condition: Here is the code:

IF  (ReportOutput() in ('CSV','layoutDataXML','MHT','PDF','rawXML','singleXLS', 'spreadsheetML','XLS','XML','XLWA'))
THEN ('Y')
ELSE ('N')

I think may be adding one of the above in addition to just XLS did the trick.
Thanks,
Kamran :) :) :) 8) 8)

COGNOiSe.com - The IBM Cognos Community