Table to Report

[Guest]

I created a report based a query involving 3 tables. It worked fine. Then I
realized that in one of the tables I had 2 fields that I didn't need in my
database at all. So I went into that table and deleted two fields. These
fields were in my query which was related to the Report. Now everytime I open
my report it asks me to enter the parameter value for each field before it
will let me in. I don't have these anywhere in my report anymore and i want
to know how to get rid of hte prompt boxes for the parameter values.
Thanks in advance.
Travis

 

[Guest]

Four places that I can think of that you need to check:
1. The query - mybe the field still defined there (run the query separatly
and check if you get prompt by the parameters

2. The Report Record Surce, just as th query it might stll be defined there

3. In the report you might have this fields, open he report in design view,
and check if any of the text boxes there is bound to this fields - if that
the ase remove the fields

4. You might have used this fields in the sortin and groupng of the report -
if that the case remove them from there

It might be even all of the above, so you might need t check them all

 

[betwalk]

I created a report based a query involving 3 tables. It worked fine. Then I
realized that in one of the tables I had 2 fields that I didn't need in my
database at all. So I went into that table and deleted two fields. These
fields were in my query which was related to the Report. Now everytime I open
my report it asks me to enter the parameter value for each field before it
will let me in. I don't have these anywhere in my report anymore and i want
to know how to get rid of hte prompt boxes for the parameter values.
Thanks in advance.
Travis

----------------
Even though you may have deleted the text boxes from the report, the
references are still there somewhere. Two places to look:

--Go to the sorting and grouping dialog and be sure they are not in
there
--Go to the data tab of the report's properties, look in the underlying
query and be sure the references to these fields has be deleted. (If
the query is saved with a name, you can also just edit that.)

hth-

Betsy