CLOSE all CREATE CURSOR PreXtab (row C(10), col C(10), data C(10)) INSERT INTO PreXtab (row, col, data) ; VALUES ('Shoe Size', 'cust1', '8') INSERT INTO PreXtab (row, col, data) ; VALUES ('Birth Date', 'cust1', '1/1/90') INSERT INTO PreXtab (row, col, data) ; VALUES ('cat name', 'cust1', 'sue') INSERT INTO PreXtab (row, col, data) ; VALUES ('Shoe Size', 'cust2', '9') INSERT INTO PreXtab (row, col, data) ; VALUES ('Birth Date', 'cust2', '1/1/89') INSERT INTO PreXtab (row, col, data) ; VALUES ('cat name', 'cust2', 'alex') INSERT INTO PreXtab (row, col, data) ; VALUES ('Shoe Size', 'cust3', '11') INSERT INTO PreXtab (row, col, data) ; VALUES ('Birth Date', 'cust3', '1/1/88') INSERT INTO PreXtab (row, col, data) ; VALUES ('cat name', 'cust3', 'ruffles') * Parm1 - output file/cursor name (default "xtab.dbf") * Parm2 - cursor only (default .F.) * Parm3 - close input table after (default .T.) * Parm4 - show thermometer (default .T.) * Parm5 - row field (default 1) * Parm6 - column field (default 2) * Parm7 - data field (default 3) * Parm8 - total rows (default .F.) * Parm9 - totaling options (0-sum, 1-count, 2-% of total) * Parm10 - display Null values DO HOME() + "VFPXTab" WITH "RawXTab",.T.,.F.,.T.,1,2,3,.F.,0,.T.My solution is to prepend the birthdate to the column field like so:
INSERT INTO PreXtab (row, col, data) ; VALUES ('Shoe Size', '19900101cust1', '8')and then in the report construct the column header like so:
substr(field(1),9)Thanks for responding,
>>DO HOME() + "VFPXTab" WITH "RawXTab",.T.,.F.,.T.,2,1,3,.F.,0,.T. >>>>