Print Page - Case statement

Title: Case statement
Post by: sujitgouda on 13 Aug 2014 08:24:15 AM

I have a field called Regions which has values: BD. EDJ and WH
I have a field called Territory which has a value: MF, MAG, SMA

While using cascading prompt I don't want BD and WH to include MF. Only when I filter out EDJ I should be able to see MF and the query set should filter out data for the same.

How do I do this ?

Title: Re: Case statement (Resolved)
Post by: sujitgouda on 13 Aug 2014 11:30:26 AM

This is done.

Changed the data item to show the value only when the ?parameter_1?= 'EDJ'

Thanks.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: sujitgouda on 13 Aug 2014 08:24:15 AM