How can I build a report from a table or a query, from code, and each time the table (query) contains different fields and different number of fields ?
I used "CreateReport" and rptObject.Source... , but I don't got the fields, a got an empty report.
How can I attache the fields of table(query).
Thanks

Having spend months, years, decades trying to do a report for a dynamic crosstab I found a sample database which I will send you.

Good luck!

Hi there,

I was just wondering if you still have that sample database.

I have a request for users to check/uncheck fields they wish to report on. It sounds as though your sample would be ideal.

Thanks
Smilla

check out this thread (http://www.access-programmers.co.uk/forums/showthread.php?t=62587) there is a sample database of a dynamic report!