Re: report with tdatabase condition - resolved !!

Silvio.Falconi · Post by **Silvio.Falconi** » Fri Apr 30, 2021 5:16 pm

I wish insert the shadow of this column it ::oPrenota:datapayed not empty

COLUMN TITLE "CLIENTE " DATA ::oPrenota:GUEST SHADOW

how I can resolve ?

Post by **Antonio Linares** » Sat May 01, 2021 7:57 am

Silvio,

Try it this way:

COLUMN oCol TITLE "CLIENTE " DATA ::oPrenota:GUEST SHADOW

ACTIVATE REPORT ... ON STARTLINE oCol:lShadow := ! Empty( ::oPrenota:datapayed )

Silvio.Falconi · Post by **Silvio.Falconi** » Sat May 01, 2021 3:32 pm

Antonio,
give me this error

Error description: Error BASE/1003 Variabile inesistente: OCOL

Stack Calls
===========
Called from: source\spiaggia\PSituaz.prg => (b)TREPSITUAZIONE_ACTIVATE( 81 )

I sent you a test

Post by **Antonio Linares** » Sun May 02, 2021 2:16 pm

A "local oCol" is missing

Silvio.Falconi · Post by **Silvio.Falconi** » Sun May 02, 2021 4:11 pm

Antonio Linares wrote:A "local oCol" is missing

I put this local variable and it make error same

Code: Select all | Expand

METHOD Activate() CLASS TRepSituazione
   local oCol

   IF  ::lActivate

   ::oReport:bSkip := { || ::oPrenota:skip(1) }

   ACTIVATE REPORT ::oReport WHILE !::oPrenota:eof()     ;
              ON STARTLINE oCol:lShadow := ! Empty( ::oPrenota:DATAPAYED )

ENDIF

   ::oFont:End()

   ::oPrenota:SETFILTER("")
   ::oPrenota:Close()

   RETURN NIL

Silvio.Falconi · Post by **Silvio.Falconi** » Sun May 02, 2021 4:16 pm

Corrected

ACTIVATE REPORT ::oReport WHILE !::oPrenota:eof() ;
ON STARTLINE ::oReport:aColumns[ 3 ]:lShadow:= ! Empty( ::oPrenota:DATAPAYED )