Cognos Text Box prompt Issue

Hi ,
suppose if a report contains n pages like page1,page2, upto pagen, in a textbox prompt when we enter 1 page1 should display,when i enter 2 page2 should display,can anyone suggest the answer?

Questions by itspaddu

Showing Answers 1 - 6 of 6 Answers

buddy

  • Aug 2nd, 2011
 

well, two things to do.
1- Use Static Choice for Prompt
2- Apply render variable to render the pages

  Was this answer useful?  Yes

Chandra Kiran

  • Aug 17th, 2011
 

You can use the Render Variable method.

Make a String Variable and place the CASE WHEN Statement with the Parameter values. In the Page Explorer, go to Page Properties, Set the Render Variable and select the respective choice for the Page.

I believe, that can solve your problem.

Code
  1.  

  2. CASE WHEN

  3. ?Par_Text_Prompt? = 'Page 1' then 'P1'

  4. ?Par_Text_prompt? = 'Page 2' then 'P2'

  5. .....

  6. .....

  7. END

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions