FiveTech Software tech support forums

... 3]:bOnPostEdit :={|oCol,xVal,nKey| If(nKey==VK_RETURN,(COMPONENTES[oBrw:nArrayAt][ 3]:=xVal,oBrw:Refresh(),oBrw:MakeTotals()),)} oBrw:aCols[ 3]:nFooterType :=AGGR_SUM oBrw:aCols[ 3]:nFootStrAlign :=AL_RIGHT oBrw:Maketotals() Muchas gracias! Roberto

Here some samples oBrw:Age:bSumCondition := { |v,o| o:Value % 2 == 1 }, ; oBrw:State:nFooterType := AGGR_COUNT, ; oBrw:State:bSumCondition := { |v,o| "A" $ o:Value }, ; oBrw:Salary:nFooterType := AGGR_SUM, ; oBrw:Salary:bSumCondition := { || .NOT. FIELD->MARRIED ...

Postby nageswaragunupudi » Sun May 03, 2020 6:54 am CODE: SELECT ALL EXPAND VIEW WITH OBJECT oCol :nFooterType := AGGR_SUM :cEditPicture := "€ 99,999.99" :cDataType := "N" END In case of empty arrays we need to inform the datatype of the column by setting ...

Postby nageswaragunupudi » Sun May 03, 2020 6:54 am CODE: SELECT ALL EXPAND VIEW WITH OBJECT oCol :nFooterType := AGGR_SUM :cEditPicture := "€ 99,999.99" :cDataType := "N" END In case of empty arrays we need to inform the datatype of the column by setting ...

:aCols[ 3 ]:nFooterType := :aCols[ 5 ]:nFooterType := AGGR_SUM Is this also hapening when you just use 1 of them ? :aCols[ 5 ]:nFooterType := AGGR_SUM and if you made 2 different with object oBrwpos and obrw.... Thanks Mac, for ...

:aCols[ 3 ]:nFooterType := :aCols[ 5 ]:nFooterType := AGGR_SUM

Is this also hapening when you just use 1 of them ?

:aCols[ 5 ]:nFooterType := AGGR_SUM

and if you made 2 different with object oBrwpos and obrw....

... } oBrw:aCols[ 7 ]:lAutoSave := .T. oBrw:aCols[ 8 ]:nFooterType:= AGGR_TOTAL oBrw:MakeTotals() oBrw:CreateFromCode() cGrad := PadR( GradStr( BrwGrad( oBrw ) ), 128 ) ACTIVATE DIALOG oDlg CENTERED on INIT ...

... } oBrw:aCols[ 7 ]:lAutoSave := .T. oBrw:aCols[ 8 ]:nFooterType:= AGGR_TOTAL oBrw:MakeTotals() *---------------- //-------------------------------------------------------------------------------------------------------------------------------------------------------------// ...

Hola a todos Tengo un xBrowse que totaliza una par de columnas con las funciones: obrw:aCols[4]:nFooterType := AGGR_TOTAL Lo que me gustaría es tomar el valor de AGGR_TOTAL como variable para luego hacer una suma con otra variable ajena al Xbrowse. Por ejemplo: nGeneral:= ...

... :lDisplayZeros := (.F.) WITH OBJECT :Arriendo :cOrder := "A" :bFooter := { || Len( oBry:aSelected ) } END WITH OBJECT :Importe :nFooterType := AGGR_SUM :bSumCondition := { || AScan( oBry:aSelected, oBry:BookMark ) > 0 } :cFooterPicture:= "@Z 9,999,999,999.99" :nTotal ...

... en tu code, 1) cuando definis el xbrowse tenes que ponerle FOOTERS o activar oBrw:lFooter:= .t. 2) cuando definis la columna WITH OBJECT :Importe :nFooterType := AGGR_SUM :bSumCondition := { || AScan( oBry:aSelected, oBry:BookMark ) > 0 } :cFooterPicture := "@Z 9,999,999,999.99" // ...

Francisco: Primero, gracias por el apoyo Fijate que me tira error // WITH OBJECT :aCols[08] WITH OBJECT oBrw:HDR_GAS :nFooterType := AGGR_SUM :bSumCondition := { || ! oRsHdr:Fields("HDR_CAN"):Value } :cFooterPicture := "@Z 9,999,999,999.99" END Saludos Lo hago ...

Francisco: Primero, gracias por el apoyo Fijate que me tira error // WITH OBJECT :aCols[08] WITH OBJECT oBrw:HDR_GAS :nFooterType := AGGR_SUM :bSumCondition := { || ! oRsHdr:Fields("HDR_CAN"):Value } :cFooterPicture := "@Z 9,999,999,999.99" END Saludos

I allready tested with WITH OBJECT oBrowse:aCols[ 11] :nFooterType := AGGR_SUM :cEditPicture := "€ 999,999.99" :nDataStrAlign := AL_RIGHT END the xbrowse is @ 120, 02 XBROWSE oBrowse OF oDlg ; COLUMNS 1,2,3,4,5,6,7,8,9,10,11; HEADERS "Ico","Tipo","Servizio","Q.tà","Costo","Tot ...

https://i.postimg.cc/MZ7xccN9/errore-footer.jpg on xbrowse I set WITH OBJECT oBrowse:aCols[ 11] :nFooterType := AGGR_SUM :cEditPicture := '@ €99,999.99' END also I use :nDataStrAlign := AL_RIGHT I not see the symbol of euro while on another procedure ( same source ...