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 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