crystal-reports - conditional color formatting based on string and number

Question

I am trying to fix the logic in my report where any {nresult} > {flaglevel} =crred. This works except we initially didn't take into account the fact that {flaglevel} defaults to 0 unless a specific number is entered. so ALL {nresult} are red even if {flaglevel} is just the default.

{nresult} is a number and {flaglevel} is a string. The current code is

If {PRM_SxData.nResult} > tonumber({PRM_SxData.FlagLevel}) 
then crRed 
Else crBlack

I tried to make a separate formula for {flaglevel} except I have to have a number after else so it doesn't work.

if tonumber ({PRM_SxData.FlagLevel}) > 0
then tonumber({PRM_SxData.FlagLevel})
else " "

Essentially what I need is something like this:

If {PRM_SxData.nResult} > tonumber({PRM_SxData.FlagLevel}) //where flaglevel >0 
then crRed 
Else crBlack

标签： crystal-reports

Answer 1

I am kinda pessimist about user input and i think R.McMillan made a good question, so i would go with something like this:

If (not isnull({PRM_SxData.FlagLevel))
AND {PRM_SxData.FlagLevel} <> ""
AND {PRM_SxData.nResult} > tonumber({PRM_SxData.FlagLevel})
then crRed 
Else crBlack

Please, try this and let us know what happened.

If it does not work, print {PRM_SxData.FlagLevel} somewhere to check its value.