I am trying to suppress the detail line on my report but nothing I have tried has worked.
There is a field on my report called @Results 2 which looks like this:
I want to suppress lines that have a space in the @Results 2 field. I have tried putting this in the conditional suppress:
That didn’t work.
So I created another field called @SetUpDSuppress to do this:
I put it on the Detail line (and it works). In the conditional suppress on the detail line:
That didn’t work either.
I am guessing it has to do with when things are being evaluated but not sure how to control it. Any suggestions?
There is a field on my report called @Results 2 which looks like this:
Code:
[COLOR=#17365d][COLOR=#17365d]If {Observe.Obs_Float} <> 0 Then[/COLOR]
[COLOR=#17365d] CStr ({Observe.Obs_Float})[/COLOR]
[COLOR=#17365d]Else[/COLOR]
[COLOR=#17365d]If {Observe.Obs_Choice} <> 0 Then[/COLOR]
[COLOR=#17365d] CStr ({Observe.Obs_Choice})[/COLOR]
[COLOR=#17365d]Else[/COLOR]
[COLOR=#17365d]If {Observe.Obs_String} <> ' ' Then[/COLOR]
[COLOR=#17365d] {Observe.Obs_String};[/COLOR]
[/COLOR]
Code:
[COLOR=#17365d][COLOR=#17365d]{%Results 2} = ' ';[/COLOR]
[/COLOR]
So I created another field called @SetUpDSuppress to do this:
Code:
[COLOR=#17365d][COLOR=#17365d]NumberVar ShowDetails;[/COLOR]
[COLOR=#17365d]EvaluateAfter ({@results 2});[/COLOR]
[COLOR=#17365d]If {@results 2} = ' ' Then[/COLOR]
[COLOR=#17365d] ShowDetails := 0[/COLOR]
[COLOR=#17365d]Else[/COLOR]
[COLOR=#17365d] ShowDetails := 1;[/COLOR]
[/COLOR]
Code:
[COLOR=#17365d][COLOR=#17365d]NumberVar ShowDetails;[/COLOR]
[COLOR=#17365d]ShowDetails := 0[/COLOR]
[/COLOR]
I am guessing it has to do with when things are being evaluated but not sure how to control it. Any suggestions?