cross tab report asks for parameter values

  • Thread starter Thread starter eddiec
  • Start date Start date
E

eddiec

hi everyone,

I have a crosstab report that I have modified to suit a new production
process. The only difference between the two reports is the names of the
items that are being manufactured. The names of the items have been changed
in the manufactured items table and these appear in the drop down selection
list for text box values (ie the cross tab query is functioning correctly.)

However....

When I run the report I get asked for the values of the parameter (item a,
item b etc.) The report then displays the value that I enter and not the
actual value that is returned from the cross-tab query.

I know that the query is executing because when I select a larger date range
the report takes longer to come up.

Debugging this report is somewhat difficult because the mdb file that
contains all cross-tab queries is launched externally by an adp project that
contains all non-cross tab reports and forms.

Help!

Why does the report not assign the values returned from the query to the
text boxes? Why does the report work with the old item names but not with
the new item names?

I have tried using IN in the cross-tab ( PIVOT Items.ItemName In ("Item
A","Item B","Item C","Item D")) but still have the same outcome.

TIA

eddiec :-)
 
I have tried just running the query and this works fine, I get the result
set without being prompted for parameters
 
Back
Top