I have 4 crosstab queries that count different types of registrations. The results are:
Name Total 04/01 04/02 04/04 etc.
I would like to put all 4 query results into 1 report. I guess there would be 1 master report and 3 subreports which I haven't tackled and not quite sure how to go about it.
The bigger question: The dates come over as part of the SQL retrieval. For example this month I am getting April data. Next month I will get May data.
Is there a way to setup the column labels to change to the month/day that the data displays.
Name Total 04/01 04/02 04/04 etc.
I would like to put all 4 query results into 1 report. I guess there would be 1 master report and 3 subreports which I haven't tackled and not quite sure how to go about it.
The bigger question: The dates come over as part of the SQL retrieval. For example this month I am getting April data. Next month I will get May data.
Is there a way to setup the column labels to change to the month/day that the data displays.