ed:
I definitely don't want to change the source code for xtab because I use it in other programs as well. The fields that I know for sure will be included in each out put table are: total, company plus I add two more: year and lossratio. I want the data looks like this in the grid: company, year, total, lossratio and I don't care the order for the rest of the fields(they will be displayed). I tried to use sql to select company, year,total, lossratio how do I finish the sql statement for the rest of the field and I don't know the name of the field for each time I run the procedure. Could you help me on that ?
thanks.
sherry