Crosstab query fields do not show up in report

[zz]

I create a query which requires the ability to filter the data with a date
range. I then run a crosstab query with the results. Everything works out
find.

When i go to create a report -- wtih report wizard -- no fields show up?

How can I create a report using the final data of the crosstab -- but
filtering by date range ?

 

[Allen Browne]

What are the column headings of your crosstab?

If they are dates (e.g. 1/1/2008), then when you filter different date
ranges, they won't match the field names in your report. If that is the
problem, see if you can alias the fields the way Duane Hookom explains in:
dynamic monthly crosstab reports
at:
http://www.access.hookom.net/DynamicMthlyCrosstabRpt.htm

If that is not the problem, you may need to:
a) supply the full list of possible column headings in the Column Headings
property of the crosstab query, and
b) declare the parameters for the date range.

Details of both in:
Crosstab query techniques
at:
http://allenbrowne.com/ser-67.html

 

[zz]

I have the crosstab working by putting parameters in the crosstab -
start_date and end_Date.

My data contains Chapter, Type, Quantity and Date. I want to pull out the
data by date range (the date does nto show up in the crosstab - should it?)

My crosstab looks as follows:
TYPE1 TYPE2 TYPE3
CHAPTER Sum# Sum# sum#
CHAPTER2
CHAPTER3

When I run the cross tab i see the results as I expect. When I go to
report wizard and select the crosstab report -- under AVAILABLE FIELDS its
totally blank.

Any ideas?

zz

 

[Allen Browne]

The 2nd link explains how to set up the Column Headings property.

From your example, it needs to look like this:
"TYPE1"; "Type2"; "Type3"