COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: nyagi on 16 Apr 2009 10:55:12 PM

Title: build prompt to choose pages to show
Post by: nyagi on 16 Apr 2009 10:55:12 PM
i've done this by creating a variable and used in Render Variable properties. Then created a prompt to show different values. Problem is, if user choose two or more values, all reports run. its either its running properly when one value was choosen or everything else was choosen.

any other approach I can use?
Title: Re: build prompt to choose pages to show
Post by: nugget on 28 Apr 2009 08:42:12 AM
i dont know how you can navigate to a page via a prompt. but you can add several blocks on your page. then you switch typ of box to none for everyblock. then you create a prompt with static values maybe "block1","block2" ... so on

then you create a variable (stringvariable) ParamDisplayValue('Promptparameter') and add your static values of the prompt as values for your variable.

now you add the variable as stylevariable to your blocks. over the condition explorer you can say which block is shown when the prompt is change.

i hope you understand my tutorial my english is not so good :-)

i hope this solution will help you



Title: Re: build prompt to choose pages to show
Post by: vij on 29 Apr 2009 02:01:34 AM
Hi nyagi ,

try the following steps ,it works at my side.
version that i am using is (Cognos 8.2)

1)create 3 report pages.
2)create 1 prompt page with value prompt on it ,and static choices as page1,page2,page3 etc...
3)set prompt page properties as "Multi-Select =yes" ans "Select UI =check Box group".
4)we have 3 report pages,so create 3 boolean variables and put an expression as ....
boolean 1=ParamDisplayValue('Parameter1') contains 'page1'
boolean 2=ParamDisplayValue('Parameter1') contains 'page2'
boolean 3=ParamDisplayValue('Parameter1') contains 'page3'

4)now go to the report page 1 and select ancestor as "PAGE" and apply Render Variable as boolean 1 for Page 1
5)repeat the step 4 for the rest two pages .
6)now run the report .
7)if you select page 1 and page 3 in prompt the report will give you that respective pages only.


hope it will help you ...


regards,
vij
:)









Title: Re: build prompt to choose pages to show
Post by: nyagi on 27 May 2009 01:34:41 AM
thanks vij..

works like a charm. will apply this instead of the one i made.
Title: Re: build prompt to choose pages to show
Post by: NaviGator on 27 May 2009 03:49:47 AM
Have you tried the 'Table Of Content' tool in the insertable objects ? I think it could help you.

Thanks ..