Creating Report Based on Crosstab Query

Hey all.

I am trying to create a report based on a crosstab query for a count. I am
limiting the data based on a date range, being pulled in from a form which
generates the report.

I set the range in the first "filter" query, and then added formatting along
the way to get an end result. I then took the end result and used it to
supply the crosstab query as a dataset.

I then set parameters exactly the same as found on the first query to limit
data. Everything goes fine. Then when the report is being created, it
continually asks for the dates from the form
(form!frm_report_dates!date_start). I cannot even add a control to the
report because I continue to get interupted in design mode.

Any help is appreciated.

Is the form open with a value in the date_start? Have you set the column
headings property of the crosstab query?

--
Duane Hookom
Microsoft Access MVP


"PiB311" wrote:

Hey all.

I am trying to create a report based on a crosstab query for a count. I am
limiting the data based on a date range, being pulled in from a form which
generates the report.

I set the range in the first "filter" query, and then added formatting along
the way to get an end result. I then took the end result and used it to
supply the crosstab query as a dataset.

I then set parameters exactly the same as found on the first query to limit
data. Everything goes fine. Then when the report is being created, it
continually asks for the dates from the form
(form!frm_report_dates!date_start). I cannot even add a control to the
report because I continue to get interupted in design mode.

Any help is appreciated.

Form is not open. I have set the column values. When I keep the form open,
the message box does not pop up, but the application runs enormously slow. I
am only looking at maybe 200 records in the query, and it does not seem that
the report design mode should run as slow as it does.

If the issue is the form, why would it be required to be open? The available
field list is still constant, correct?

Another thing I don't understand... I clicked into the header section for
one of my subgroups, and instead of copying a control, copied the "header"
(by accident). When I went to paste, it pasted a label with
[forms]![frm_report_dates]![dates_start]. Can anyone explain that?

Thanks!


"Duane Hookom" wrote:

Is the form open with a value in the date_start? Have you set the column
headings property of the crosstab query?

--
Duane Hookom
Microsoft Access MVP


"PiB311" wrote:

Hey all.

I am trying to create a report based on a crosstab query for a count. I am
limiting the data based on a date range, being pulled in from a form which
generates the report.

I set the range in the first "filter" query, and then added formatting along
the way to get an end result. I then took the end result and used it to
supply the crosstab query as a dataset.

I then set parameters exactly the same as found on the first query to limit
data. Everything goes fine. Then when the report is being created, it
continually asks for the dates from the form
(form!frm_report_dates!date_start). I cannot even add a control to the
report because I continue to get interupted in design mode.

Any help is appreciated.

Just open the form. If your application runs enormously slow when the form is
open then something else is going on. Do you have a timer event running in
the form?

What is the SQL view of your crosstab?

I don't know what you would have expected to paste.
--
Duane Hookom
Microsoft Access MVP


"PiB311" wrote:

Form is not open. I have set the column values. When I keep the form open,
the message box does not pop up, but the application runs enormously slow. I
am only looking at maybe 200 records in the query, and it does not seem that
the report design mode should run as slow as it does.

If the issue is the form, why would it be required to be open? The available
field list is still constant, correct?

Another thing I don't understand... I clicked into the header section for
one of my subgroups, and instead of copying a control, copied the "header"
(by accident). When I went to paste, it pasted a label with
[forms]![frm_report_dates]![dates_start]. Can anyone explain that?

Thanks!


"Duane Hookom" wrote:

Is the form open with a value in the date_start? Have you set the column
headings property of the crosstab query?

--
Duane Hookom
Microsoft Access MVP


"PiB311" wrote:

Hey all.

I am trying to create a report based on a crosstab query for a count. I am
limiting the data based on a date range, being pulled in from a form which
generates the report.

I set the range in the first "filter" query, and then added formatting along
the way to get an end result. I then took the end result and used it to
supply the crosstab query as a dataset.

I then set parameters exactly the same as found on the first query to limit
data. Everything goes fine. Then when the report is being created, it
continually asks for the dates from the form
(form!frm_report_dates!date_start). I cannot even add a control to the
report because I continue to get interupted in design mode.

Any help is appreciated.