Can't belive this can't be done, so here goes...
Got an A3 report that has 30-odd labels down the left hand side that relate to various values.
It's impossible for us (or the client) to know the number of departments they are reporting on, so we've created a sub-report that automatically increases the number of columns and plonked this sub-report to the right of the labels.
It works absolutely sweet as a nut.!
Until...
The number of columns exceeds the page width. The columns DO go onto the second page (so if there were 20 departments, 9 would be on page 1, 10 on page 2 and 1 on page 3). But the problem is the labels only appear on page 1.
Is there a way to have these labels appear on every page, or can someone think of another way on how to create a report that allows me to define a set of values for a column, and the column(s) automatically 'grow'.
Got an A3 report that has 30-odd labels down the left hand side that relate to various values.
It's impossible for us (or the client) to know the number of departments they are reporting on, so we've created a sub-report that automatically increases the number of columns and plonked this sub-report to the right of the labels.
It works absolutely sweet as a nut.!
Until...
The number of columns exceeds the page width. The columns DO go onto the second page (so if there were 20 departments, 9 would be on page 1, 10 on page 2 and 1 on page 3). But the problem is the labels only appear on page 1.
Is there a way to have these labels appear on every page, or can someone think of another way on how to create a report that allows me to define a set of values for a column, and the column(s) automatically 'grow'.