COGNOiSe.com - The IBM Cognos Community

Hi,

I have three prompt pages .

I haveÃ,  value prompt on the prompt page .

Top of the page there is a table cell in which i have some text = ParamDisplay.
For Example :
In the Value prompt if I select the departmentÃ,  code it should show department code of particular department.

If i won't select any department it should display the text = 'ALL Department"

Thanks
Ã, 

gops,
You will need to set a default selection of "ALL Departments" in your prompt.  Then, in your filter type something like the following...

[Dept] = 'ALL Departments' or [Dept] = ?paramDept?

thanks for your immediate reply.

But i am not able to set default selction.

If i select the ValueÃ,  in the value prompt it should show that value in the Table cell text.

otherwise show All department .

I forgot to mention that Text Cell is not on the prompt page, its in the report page.

waiting for your reply.

OK, instead of defining default selections, create a static choice of "ALL Departments".  This should give you what you need.

You still need to keep the filter that I gave you above because the query won't know how to interpret 'All Departments'.

HTH...Let me know if you need more clarification.

But i am not able to set static choice.

If i select the ValueÃ,  in the value prompt it should show that value in the Table cell text.

otherwise show All department .

I forgot to mention that Text Cell is not on the prompt page, its in the report page.

waiting for your reply.

Show the ParameterValue()??

I dont get it..

If my understanding is correct, you want to display the text "All Departments" when the department prompt is not chosen and when a particular department value is chosen, you want to display the Department Name.

To do this, you can use the expression, if (ParamDisplayValue("Department")='') then ('All Departments') else (ParamDisplayValue("Department")) instead of the ParamDisplayValue("Department") you are using.

Correct me if i have understood your requirement wrongly.

The parameter display won't update unless something is selected.Ã,  That's the issue here and the reason that I suggested this approach.

I assume you have other prompts on the page.Ã,  I would set the the auto-submit to "Yes" if the users are permitted to select only one value and use cascading prompts for your other parameters.

Thanks for ur replys..

But what my problem that i am able to do some of the Table by using Paramdisplayvalue()...

Not able to do for some of the text cell and Value Prompt...



Thanks and regards

gops, can you pls be a bit more clear on ur issue!
the paramdisplay works correctly for u in table cells and not in text items?