Table cell and Value prompt

[koolbachi]

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
Ã, 

[bdybldr]

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?

[koolbachi]

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.

[bdybldr]

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.

[koolbachi]

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.

[CoginAustin]

Show the ParameterValue()??

I dont get it..

[anoop_ind2]

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.

[bdybldr]

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.

[koolbachi]

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

[anoop_ind2]

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?