getting rid of parameter value

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

hi,

Everytime I click on a preview for a report, it asks me
for a parameter value (ie Extension #). How do I get rid
of the parameter value so that the preview only pops up?

Thanks!
 
hi,

Everytime I click on a preview for a report, it asks me
for a parameter value (ie Extension #). How do I get rid
of the parameter value so that the preview only pops up?

Thanks!
Click to expand...

If the [Extension #] is not a query parameter, then you have a control
in your report that uses it in it's control source, i.e.
=[PhoneNumber] & "-" & [Extension #], but [Extension #] is not
included in the report's record source.
OR...
at one time you used a control [Extension #] and have since deleted
it, without also deleting a reference to it, usually in the report's
Sorting and Grouping dialog box.
 
where is the report's sorting and grouping dialog box???

-----Original Message-----
hi,

Everytime I click on a preview for a report, it asks me
for a parameter value (ie Extension #). How do I get rid
of the parameter value so that the preview only pops up?

Thanks!
Click to expand...

If the [Extension #] is not a query parameter, then you have a control
in your report that uses it in it's control source, i.e.
=[PhoneNumber] & "-" & [Extension #], but [Extension #] is not
included in the report's record source.
OR...
at one time you used a control [Extension #] and have since deleted
it, without also deleting a reference to it, usually in the report's
Sorting and Grouping dialog box.
Click to expand...
 
where is the report's sorting and grouping dialog box???
-----Original Message-----
hi,

Everytime I click on a preview for a report, it asks me
for a parameter value (ie Extension #). How do I get rid
of the parameter value so that the preview only pops up?

Thanks!
Click to expand...

If the [Extension #] is not a query parameter, then you have a control
in your report that uses it in it's control source, i.e.
=[PhoneNumber] & "-" & [Extension #], but [Extension #] is not
included in the report's record source.
OR...
at one time you used a control [Extension #] and have since deleted
it, without also deleting a reference to it, usually in the report's
Sorting and Grouping dialog box.
Click to expand...
Click to expand...

In Report Design View, click on View + Sorting and Grouping.
 
Back
Top