G
Guest
I have finally figured out how to create a crosstab query based on user input
from a form. However, now I am having trouble creating the report.
Ideally, I would like to have the user select the PRODUCTS he/she would like
to view the measures for and then be able to click an "OKAY" button where the
report would be generated. In other words, I would like the report to be set
up where the column headings are dynamic based on what the user has selected
on the form...
I would like the report to look something like this...
Prod1 Prod2 Prod3
Measure 1 score11 score12 score13
Measure 2 score21 score22 score23
Measure 3 score31 score32 score33
Does anyone have any ideas as to how I can get from the crosstab query to
the report?? I have been racking my brain and trying different things for
days now with no success!
from a form. However, now I am having trouble creating the report.
Ideally, I would like to have the user select the PRODUCTS he/she would like
to view the measures for and then be able to click an "OKAY" button where the
report would be generated. In other words, I would like the report to be set
up where the column headings are dynamic based on what the user has selected
on the form...
I would like the report to look something like this...
Prod1 Prod2 Prod3
Measure 1 score11 score12 score13
Measure 2 score21 score22 score23
Measure 3 score31 score32 score33
Does anyone have any ideas as to how I can get from the crosstab query to
the report?? I have been racking my brain and trying different things for
days now with no success!