Print Page - Sort column as per user selection

Title: Sort column as per user selection
Post by: krunal on 28 Nov 2016 05:15:37 AM

Hi Guys,

report requirement is

on report page we have value prompt with dropdown list

In that we have 3 values A, B and C

we also have list report with Column A,B and C

now when user selects value A in value prompt data should be sort as per column A
and if user selects value B in value prompt data should be sort as per column B and same with C as wel.

Sorry for my poor English

Thanks in advance

Title: Re: Sort column as per user selection
Post by: hespora on 28 Nov 2016 06:59:43 AM

I am much too lazy to type it all up, so: http://www.mycci.com/using-prompt-token-syntax-to-create-efficient-reports/

Title: Re: Sort column as per user selection
Post by: Penny on 29 Nov 2016 12:48:51 PM

Thank-you hespora.

Your article was very helpful to me. I didn't really understand tokens until now.

Title: Re: Sort column as per user selection
Post by: hespora on 30 Nov 2016 02:37:05 AM

glad it helped you, but: not my article. I'm not affiliated with them at all.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: krunal on 28 Nov 2016 05:15:37 AM