topic-32415

Board index FiveWin for Harbour/xHarbour Filtering a report.

Posts: 723

Joined: Tue Sep 04, 2007 08:45 AM

Filtering a report.

Posted: Wed May 11, 2016 06:21 AM

Guys:

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

         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 (fw): Select all Collapse

      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

Posts: 44162

Joined: Thu Oct 06, 2005 05:47 PM

Re: Filtering a report.

Posted: Wed May 11, 2016 08:04 AM

Gustavo,

You may check how the nTotal variable is being modified:

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

regards, saludos

Antonio Linares
www.fivetechsoft.com

HunterEC

Posts: 723

Joined: Tue Sep 04, 2007 08:45 AM

Re: Filtering a report.

Posted: Wed May 11, 2016 02:14 PM

Antonio:

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

FiveTech Support Forums

Filtering a report.

Re: Filtering a report.

Re: Filtering a report.

Continue the discussion