I posted this in the reports area by mistake..
This thread describes a lot of what I need to do:
Thread703-562204 I need to make the columns fill the page. From what I gather from that thread, a dynamic crosstab report will have empty space as the boxes collapse down across the unused text boxes (i.e. if you have all 12 months as columns, but the dynamic query only needs months 02-06, they'll collapse to the left leaving empty space on the right).
The crosstab report I'm running contains Text (I use First - Value) instead of a Sum or Average. Thus, I want the text boxes to be evenly justified across the page. This is easily done using the Design Wizard run against the crosstab query, however, I do not know of a way to run the Design Wizard several times within a report in order to obtain the different sets of columns needed to complete the report. Is there a way to do that? If not, I will need to create a report completely with VBA in order to have justified text boxes across the page for my dynamic crosstab query.
Does this make sense?
thx!
Q-
This thread describes a lot of what I need to do:
Thread703-562204 I need to make the columns fill the page. From what I gather from that thread, a dynamic crosstab report will have empty space as the boxes collapse down across the unused text boxes (i.e. if you have all 12 months as columns, but the dynamic query only needs months 02-06, they'll collapse to the left leaving empty space on the right).
The crosstab report I'm running contains Text (I use First - Value) instead of a Sum or Average. Thus, I want the text boxes to be evenly justified across the page. This is easily done using the Design Wizard run against the crosstab query, however, I do not know of a way to run the Design Wizard several times within a report in order to obtain the different sets of columns needed to complete the report. Is there a way to do that? If not, I will need to create a report completely with VBA in order to have justified text boxes across the page for my dynamic crosstab query.
Does this make sense?
thx!
Q-
