We are using codes as use values and descriptions for display values for parameters of our global filters on a dahsboard.
We need to show the prompt selections on a drill-through report, abviously descriptions. This drill-through report is launched in a separate window. We drill-through from dashboard to a summary report and then to a detail level report.
Our single select parameter is displayed fine with a paramdisplay value funtion in a singleton.
The multi-select parameters are being displyed as codes with paramdisplayvalue function. If we use a singleton, only one of the values(description) is being displayed, even when multiple values were selected.
Can some one help us display the display values insted of use values?
If the values are not static...take another query in detail report pass the parameters in the query...take the new list in header and take the desired coulumn in the list it will work.
A singleton is a query container and you don't need a query container to display a layout calculation. Just create a layout calculation for ParamDisplay (not ParamDisplayValue) and place it on your page where every you like.
If you need to present multiple things that are coming from a query, then a singleton is not the right container choice. As the name implies, it is meant for only a single value.
I have a similar issue. The ParamDisplayValue returns the USE value as oppose to the DISPLAY value when drilling through.
Thoughts?