Parameters displayed on Report

[JennyO]

I am trying to get the selected paraments from our prompt page to show on the report when it runs. I have the following espressiong string on the report that I thought would make it so that the paraments would be printed on the report, but it is coming up blank.

ParamDisplayValue("Starting Check Date") + ' - ' + ParamDisplayValue("Ending Check Date")

What am I missing?

[Lynn]

The parameter name should be in single quotes rather than double quotes. Make sure you are using a layout calculation and then drag in the parameter from the parameters tab to ensure you are not typing the parameter name incorrectly. You could also try ParamValue instead of ParamDisplayValue, but I wouldn't think that is the problem.

[JennyO]

Thanks for the help. It wasn't the quotes, as when I did it from selecting instead of typing, it came up with double quotes. But by selecting it the right way, I got what I needed. :)

[Bark]

The issue is that with your expression, if any of the parameters is null (not selected), the whole expression is null as "null + anything = null".

If you want to avoid this try:

IF(ParamValue('X') is missing) THEN ('') ELSE (ParamDisplayValue('X')) +
IF(ParamValue('Y') is missing) THEN ('') ELSE(ParamDisplayValue('Y'))

Regards,

Bark