If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report from a Crosstab w/Parameters
I'm working on a crosstab query that has parameters. I read an article that
said to add the parameters to the Query/Parameters as well as in the criteria row. The query runs fine now but I have a problem with the report that is based on that query. When I run the report, it asks me to fill in the parameters over and over again, but doesn't get to the report (at least I wasn't patient enough to try it for more than 3 times). When I get to Design View of the report, all of the fields listed in the Detail section show up as if they are not fields that are in the data source. Any ideas as to what I can do to fix this problem? I appreciate any help you (or anyone replying to this) can give! Thanks. |
#2
|
|||
|
|||
Report from a Crosstab w/Parameters
First check the spelling of the parameters and make sure you have not made an
error there. Next make sure your report has the correct source. Last be aware that you need to be sure that the query always returns the same columns of data. If you change the parameters the number of columns may change. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County sg wrote: I'm working on a crosstab query that has parameters. I read an article that said to add the parameters to the Query/Parameters as well as in the criteria row. The query runs fine now but I have a problem with the report that is based on that query. When I run the report, it asks me to fill in the parameters over and over again, but doesn't get to the report (at least I wasn't patient enough to try it for more than 3 times). When I get to Design View of the report, all of the fields listed in the Detail section show up as if they are not fields that are in the data source. Any ideas as to what I can do to fix this problem? I appreciate any help you (or anyone replying to this) can give! Thanks. |
Thread Tools | |
Display Modes | |
|
|