Output of OPTIONAL parameters

[Sans]

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

[Lynn]

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.

Code Select Expand


ParamDisplayValue('YourParameter')


If you want the "use" value then the expression is:

Code Select Expand


ParamValue('YourParameter')


There is also a ParamCount function which is handy to determine if any response was provided and, if so, how many.

[Sans]

Thanks it works