I have a crosstab query which is of completely variable number of columns & rows.
Currently I am able to fit up to 24 data columns on an A3 landscape page but what I'd really like it to be able to do is, if required, have up to 48+ data columns and simply repeat the 3 left most title columns on the left had side of each page as the report "grows" to the right. Like you can do when you print wide reports in MS Excel.
Any ideas?
I am currently setting up the 24 columns with generic heading names and then using VB to take the column headings off the query to insert the proper names and datasources.
Many thanks,
Shaun
Currently I am able to fit up to 24 data columns on an A3 landscape page but what I'd really like it to be able to do is, if required, have up to 48+ data columns and simply repeat the 3 left most title columns on the left had side of each page as the report "grows" to the right. Like you can do when you print wide reports in MS Excel.
Any ideas?
I am currently setting up the 24 columns with generic heading names and then using VB to take the column headings off the query to insert the proper names and datasources.
Many thanks,
Shaun