Please help,

How can I present the data of cross tab query in a report. The amount of column headings can change depending on amount of data. How can this be presented in a report, due to fact that the headings can change.

Thanks

I use this:

Dynamic Report based on a Crosstab query (http://www.hitechcoach.com/index.php?option=com_docman&task=doc_details&gid=6&Itemid=28)

Hope this helps ...

Hi Thanks Again, it is exactly what I need. But I cannot get it to work. My crosstab query works fine. The only diff is that it is not running of data from a form. I take the data for other forms and tables. At the end of the day will it print all data in the database.

How will the "open" field in the code look like.

Thanks again

Sort out the problem. Did not knew that there is diff between the Report view & Print preview

I use this:

Dynamic Report based on a Crosstab query (http://www.hitechcoach.com/index.php?option=com_docman&task=doc_details&gid=6&Itemid=28)

Hope this helps ...


Glad you posted this. I was looking to print a crosstab report where the dates would be in the columns, but they can vary. Nicely done. Thanks. :)