BusinessObjects Board

Suppress Detail not working

building reports crystal reports legacy
#1

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:

If {Observe.Obs_Float} <> 0 Then
    CStr ({Observe.Obs_Float})
Else
If {Observe.Obs_Choice} <> 0 Then
    CStr ({Observe.Obs_Choice})
Else
If {Observe.Obs_String} <> ' ' Then
    {Observe.Obs_String};

I want to suppress lines that have a space in the @Results 2 field. I have tried putting this in the conditional suppress:

{%Results 2} = ' ';

That didn’t work.

So I created another field called @SetUpDSuppress to do this:

NumberVar ShowDetails;

EvaluateAfter ({@results 2});
If {@results 2} = ' ' Then
    ShowDetails := 0
Else
    ShowDetails := 1;

I put it on the Detail line (and it works). In the conditional suppress on the detail line:

NumberVar ShowDetails;
ShowDetails := 0

That didn’t work either. :hb:

I am guessing it has to do with when things are being evaluated but not sure how to control it. Any suggestions?

RenaG (BOB member since 2011-04-11)

#2

Well, I figured it out (with some help).

In the Conditional Suppress I had used {%results 2} (refering to the SQL Expression Fields) instead of the {@results 2} field (refering to the Formula Fields).

By using the {@results 2} field it works correctly.

RenaG (BOB member since 2011-04-11)

#3

The code is working nice

rodeckneil (BOB member since 2011-07-20)