Control # of columns from VB code?

[mclosson]

Does anyone know if there is there any way to control the number of columns in a CR table from VB code? I have a table in my report that needs to consist of varying numbers of columns.


Thank you for any advice,
Mike Closson

 

[glauco]

Hi,

I recommend using crosstab reports in case the number of columns is varying about the data in a table.

For example, i had to make a report from the payroll. The data's organized so that every record has EMPLOYEE, TYPE-OF-TRANSACTION, AMOUNT (just for example). I used i cross-tab so for every TYPE-OF-TRANSACTION the report will grow a column.

I hope i've been clear enough.

Good luck.