Parameters and report

  • Thread starter Thread starter Joan
  • Start date Start date
J

Joan

I had a report that pulled information from the System
Information table. I had some problems with the table and
decided to edit the table and rename some of the fields.
One of the fields I renamed was Location. I went through
and corrected the queries that were associated with the
table to make sure that they all said Service_Address
instead of Location. However, when I open one report, it
comes up with a dialogue box saying that the location
parameter is unavailable.

I've checked the codes behind it to make sure that
location has been switched to Service_Address, but I keep
getting the same error message.

Is there somewhere else to check for the code or box? Is
there something I've forgotten to change?

Any suggestions would be very appreciated!! Thanks!
 
Joan said:
I had a report that pulled information from the System
Information table. I had some problems with the table and
decided to edit the table and rename some of the fields.
One of the fields I renamed was Location. I went through
and corrected the queries that were associated with the
table to make sure that they all said Service_Address
instead of Location. However, when I open one report, it
comes up with a dialogue box saying that the location
parameter is unavailable.

I've checked the codes behind it to make sure that
location has been switched to Service_Address, but I keep
getting the same error message.

Is there somewhere else to check for the code or box? Is
there something I've forgotten to change?
Click to expand...


Check text box in the report and, if you using Sorting and
Grouping, check there too.
 
Back
Top