How do I stop the expression Enter Parameter Value?

[Guest]

I have a report that used to draw from Query A. One of the fields in the
report, "Nominator," got its information from Query A.

I've removed that field and changed the underlying query to Query B. But,
when I try to open the report, a pop-up comes up that says "Enter Parameter
Value" and says "Nominator." The thing is, the report is now drawing upon
Query B, there is no "Nominator" field in Query B and there is no "Nominator"
field in the report. Can somebody help? Thanks.

 

[Duane Hookom]

Check the Sorting and Grouping dialog.

 

[Guest]

Doing research on a similar problem. Not too clear on what is meant by the
statement "Check the Sorting and Grouping dialog." What need to be done in
the dialog?

In my case, I have created 4 groups. for the sake of argument, let's call
them grp1, grp2, grp3, grp4. They are not based on any data elements in the
tables. When I run the report, I receive the enter parameter input box for
each of these. How do I turn these off?

 

[Duane Hookom]

The Sorting and Grouping dialog is opened by View->Sorting and Grouping. If
you want to remove these, click the selector button to the left of the
expression and press the delete key.

 

[Guest]

Removing the grouping is not an option for me. Is there some way I can
programmatically override the request for the parameters?

Thanks

 

[Duane Hookom]

It isn't clear what is causing the parameters and why. If they are coming
from expression entered into the sorting and grouping then either delete
them or suggest why you won't delete them.

 

[Marg]

The parameter keeps popping up because it needs to be removed from the
Parameters dialog box in the query. Even when you remove it from the query
grid you have to remove it from the Parameters box as well.