Print Page - How do you render an individual report for EACH selected prompt value?

Title: How do you render an individual report for EACH selected prompt value?
Post by: psrpsrpsr on 20 Jun 2017 11:26:00 AM

Hello all, I have a requirement to render a report for each value that a user selects. How would I go about this? Would this employ 'Page Sets'?

Please be as detailed as possible in your answer because I'm fairly new to Cognos report design and principles.

(http://i1305.photobucket.com/albums/s557/PSRNHME/multi_select%20prompt%20to%20report%20for%20each%20value_zpsuygvws6b.jpg) (http://s1305.photobucket.com/user/PSRNHME/media/multi_select%20prompt%20to%20report%20for%20each%20value_zpsuygvws6b.jpg.html)

Thanks!

Title: Re: How do you render an individual report for EACH selected prompt value?
Post by: New_Guy on 20 Jun 2017 01:00:30 PM

Hi,
Use page sets if all the selected values has to be in one output with a separate page for each value. Use bursting if you want an output for each value.
Good luck
New guy

Title: Re: How do you render an individual report for EACH selected prompt value?
Post by: chinnucognos on 28 Jun 2017 08:56:27 AM

Suppose If your report having 4 pages,(Page1,Page2,Page3 & Page4)
then create 'value prompt' and create 'String variable' and assign to value prompt as
case
when ParamDisplayValue('Parameter1')='1'
THEN PageName ()='Page1'
when ParamDisplayValue('Parameter1')='2'
then PageName ()='Page2'
when ParamDisplayValue('Parameter1')='3'
THEN PageName ()='Page3'
when ParamDisplayValue('Parameter1')='4'
then PageName ()='Page4'
else
end

then add static Values in 'Value Prompt' as Use value=1 & display value as 'First page' and so on.........

Please let me know if it works or not

thanks,
Chinnu

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: psrpsrpsr on 20 Jun 2017 11:26:00 AM