FiveTech Software tech support forums

This is the type of csv file that we have to generate from a DBF: customer.csv ID,FIRST,LAST,STREET,CITY,STATE,ZIP,HIREDATE,MARRIED,AGE,SALARY,NOTES 1,Homer,Simpson,32179 Maiden Lane,Springfield,IL,20503-8202,1992-09-18,True,50,5900.0,This is a test for record 1 2,Ceci,Gibbard,9540 Raynes ...

... possible at a specific location. use customer XBROWSER "CUSTOMER" COLUMNS "STATE", "AGE", "MARRIED", "SALARY" SETUP ( ; oBrw:lHScroll := .f.,; oBrw:lVScroll := .f.,; oBrw:lToolbar := .f.,; // not ok oBrw:lFullGridClr := .t.,; oBrw:lIncrFilter := ...

... := { |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 }, ; //oBrw[6]:sel:bSumCondition := { || ( oBrw:cAlias )->selected ...

hi,

nageswaragunupudi wrote:Comma delimited
Eg: "FIRST,CITY,SALARY,..."

thx for Answer

nageswaragunupudi wrote:We can easily convert an array like DbStruct() to list like this:
FW_ArrayAsList( ArrTranspose( aStruct )[ 1 ] )

ah, that is nice

how does"cFieldList" look like and what Delimiter is used

Comma delimited
Eg: "FIRST,CITY,SALARY,..."

We can easily convert an array like DbStruct() to list like this:
FW_ArrayAsList( ArrTranspose( aStruct )[ 1 ] )

For example, if we are browsing customer.dbf

Code: Select all  Expand view

XbrToArray( oBrw. { "FIRST", "CITY", "SALARY" }

where FIRST, CITY, SALARY are headers of the required columns.

Buenas noches Mr Rao, que bueno se podría totaliza en la cabecera del grupo el total del SALARY?
Seria interesante
Saludos

This way it should work: 'salary' => Alltrim(transform( (cAlias)->salary,"@Z 999999.99" ) ) }) look into the console F!2 for ( n = 0; n < data.length; n++) { console.log( parseFloat( data[n].salary ) ); console.log("--"); ...

... that we keep index on FIRST,LAST and CITY for customer.dbf in the customer.cdx on the disk. Now, we want to browse fields FIRST,CITY,STATE,AGE,SALARY. Out of the 5 columns we have index on FIRST and CITY only. But we like the browse to autosort on STATE and AGE also. Then we can do: USE CUSTOMER ...

... ,; "CITY" ,; "STATE" ,; "ZIP" ,; "HIREDATE",; "MARRIED" ,; "AGE" ,; "SALARY" ,; "NOTES" } this Run ok if I wish print a barcode nCampo:= 2FIELDWBLOCK( ncampo, SELECT( "CUST" ) ) ...

... FW_DBFLOOKUP( 108, "ID", "AGE" ) ) --> nAge of ID 108 CUSTOMER->( FW_DBFLOOKUP( 99, "ID", "FIELD->SALARY += 100" ) ) --> Salary field is incremented and written to table and returns the value ITEMS->( FW_DBLOOKUP( 101, "ITEMCODE", ...

... las posiciones decimales con Xbrowse to Excel... (utilizo calc de LibreOffice) También con el ejemplo repxb01.prg me ocurre lo mismo, la columna SALARY no lo envía al fichero XLS en formato numerico Gracias por vuestra ayuda, saludos, [img] https://i.ibb.co/rxhpWMp/report.png ...

... SIZE 5          COLUMN TITLE "Age" DATA ( cAlias )->AGE PICTURE "9999" RIGHT          COLUMN TITLE "Salary" DATA ( cAlias )->SALARY  PICTURE "99,999,999.99" RIGHT  TOTAL             GROUP ON ( cAlias )->STATE ;  ...

... COLUMN TITLE "Age" DATA ( cAlias )->AGE PICTURE "9999" RIGHT          COLUMN TITLE "Salary" DATA ( cAlias )->SALARY  PICTURE "99,999,999.99" RIGHT  TOTAL             GROUP ...

... Esto hace posible tener una alineación para el título de la columna diferente de las DATAs de la columna. Ejemplo de uso: COLUMN oCol TITLE "SALARY" DATA FIELD->SALARY FONT 1 oCol:nAlignTitle := RPT_CENTER Ahora el título se muestra centrado, mientras que los datos se alinean a la ...