Filtering a report.

[HunterEC]

Guys:

I have a report in which one column is based on calculations:

Code: Select all  Expand view

        COLUMN TITLE 'Sales'              ;
            DATA ( nTotal := GetSales( Inv_part, adDates ) ) ;
            SIZE 13 PICTURE "9999999.99" TOTAL
 

It works perfectly. Now if I want to filter the report so I can display only records which have sales on file, like this:

Code: Select all  Expand view

     oRep:bFor   := { || nTotal >= 0 }
 

It does NOT work, none of the records are printed. If I dropped the for block, it works perfectly. Any clues ?

[Antonio Linares]

Gustavo,

You may check how the nTotal variable is being modified:

oRep:bFor := { || MsgInfo( nTotal ), nTotal >= 0 }

[HunterEC]

Antonio:

I just re-did that and there are records matching ( nTotal > 0 ) but report comes out empty. Thank you.