Quote from: Sans on 17 Oct 2016 01:32:33 AM
Hi to all
I developped a report that has a beginning prompt with 7 filters; two are defined as compulsory while 5 are optional; everything works fine but I received the request to include in the output also the chosen parameters (when they are chosen).
My first approach was to put in the "foot" of the report a table with 7 cells (one for each parameter) and inside of them a list with the link to a query each......this approach causes that the 5 optional parametrs become compulsory !!
If I delete the added tabe (and the related lists) the 5 parameters return optional !!
Can anyone suggest the right approach ?
Thanks
If you reference a parameter inside a query container then the prompt must be answered. Use a layout calculation instead and drag in a parameter from the parameters tab. This will create an expression to show the "display" value from your prompt control.
ParamDisplayValue('YourParameter')
If you want the "use" value then the expression is:
ParamValue('YourParameter')
There is also a ParamCount function which is handy to determine if any response was provided and, if so, how many.