COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: asini on 13 Nov 2008 11:03:00 PM

Title: how to display reports based on user prompt
Post by: asini on 13 Nov 2008 11:03:00 PM
Hello Greetings To All,

actually we have 3 same reports(except date condition is different)

1) is short term liquidity (has account no, name, amount)  Condition--> Payment Date between today & nextyear same day
2) is long term liquidity(has account no, name, amount)   Condition--> Payment Date greater than  nextyear same day
3) is all liquidity(has account no, name, amount) Condition--> Payment Date greater than  Today

these three reports working fine

but as per authorities they requested us to create only one report with prompt shows options as "Short Term" , "Long Term", "Both"
when the user selects option the report has to work

once again remind you, in all three reports all columns were same just the date column condition is different

Please Help Me

Really appreciate it, Thanks in advance

asini
Title: Re: how to display reports based on user prompt
Post by: blom0344 on 14 Nov 2008 03:04:15 AM
Quick and easy solution is to merge the 3 reports into a new single one and use a new report page for each of the 3 reports. Then use a render variable to show the desired report page based on the prompt value chosen ("Short Term" , "Long Term", "Both")