If you are unable to create a new account, please email support@bspsoftware.com

 

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

Started by psrpsrpsr, 20 Jun 2017 11:26:00 AM

Previous topic - Next topic

psrpsrpsr

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.



Thanks!

New_Guy

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

chinnucognos

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
Deal with it!