Report a Crosstab query by date

[JCtheEUC]

Hello,
I am trying to build a report that will display a crosstab query. My query is prompting for a date range and running a count of the number of applications recd on those dates. When I veiw the query everything shows up correctly.

Now I would like to display this query on a report. When they click the button to open the report it will prompt them for the date range then show the report.

I have started the report but it prompts me several times for the dates. I will need the column headings to adjust to the dates they choose.

Can someone please help me? Or maybe point me in the right direction.

Thanks!

 

[SydneyGeek]

When you turn a crosstab into a report, you need to specify the parameters if you don't want the popups to drive you nuts.

assuming that you have 2 parameters like Enter the Start Date and Enter the End Date --
In the query design go to Query > Parameters.
Type in the names of the parameters and their data types -- eg, the first one would be Enter the Start Date and the data type would be Date/Time.

Close the dialog, save the query, and try again.

Denis

 

[JCtheEUC]

I have the parameters set in the query but I still get the multiple prompts in the report.

How do I get the column headings to dynamically change based on the date range they choose?

EG>
If the user chooses [Start Date] of 11/1/2008 and [End Date] of 11/13/2008 to get the month to date numbers.

Report should look like...(without the dashes)
-----11/1/2008----11/2/2008---11/3/2008---11/4/2008---11/5/2008 etc
row1----data----------data--------data--------data---------data-----
row2----data----------data--------data--------data---------data-----
row3----data----------data--------data--------data---------data-----
row4----data----------data--------data--------data---------data-----
row5----data----------data--------data--------data---------data-----
row6----data----------data--------data--------data---------data-----
row7----data----------data--------data--------data---------data-----

This is exactly what my query display except it actually contains the data.
How do I get my report to look like that?

Thanks!

 

[SydneyGeek]

Sorry, I missed the point that the labels were changing. That will throw the report out, so you need to get devious.
Take a look at this article ... http://www.blueclaw-db.com/report_dynamic_crosstab_field.htm

Denis

 

[JCtheEUC]

Thanks friend! That worked with some minor modifications to fit my needs.