ReportNet: Conditional formatting using a prompt parm in the condition

[JGirl]

I have a reportnet report with conditional formatting. I have a boolean variable, where if the actual >= target a red icon is displayed, otherwise a green icon is displayed.

When I hard code the value in the variable expression as

 Actual >= 40

the conditional formatting works correctly.

But...I want to be able to allow the user to enter the target value via a prompt.

If I edit the variable expression to be something like

 Actual >= ParamValue("parm_Target")

or

 Actual >= ParamDisplayValue("parm_Target")

all of the data appears with the 'No' clause formatting for all rows (regardless of whether the condition is true or false). Now I know that this is because the parameter functions output the values as strings when I am actually comparing the value to a numnber.

So...to get around this, I've created an additional column in the report called 'Min Value' with the expression

 cast_float(?parm_Target?

and changed the variable expression to

 Actual >= [Min Value]

This works correctly, but...

I dont want to have to create the extra report column and I want to be able to use the parameter value that I have entered directly in the variable expression.

Anyone know how to do this?

J

 

[JKas]

Now I know that this is because the parameter functions output the values as strings when I am actually comparing the value to a numnber."

Did you try creating a string variable instead of Boolean?

JKas