Report Parameters Problem

[Missionary]

In creating a report, I played around with making calculated text boxes that called for parameters as follows:
=[Word?] & [Other Word?]
Now, I think I've figured it out, and I have deleted my first attempts.
My problem now is that every time I preview the report it still askes me for those orrigional parameters even though the text boxes are gone. How do I stop the report from prompting me for these values?

Thanks alot.

[jaxjagfan]

In creating a report, I played around with making calculated text boxes that called for parameters as follows:
=[Word?] & [Other Word?]
Now, I think I've figured it out, and I have deleted my first attempts.
My problem now is that every time I preview the report it still askes me for those orrigional parameters even though the text boxes are gone. How do I stop the report from prompting me for these values?

Thanks alot.

The parameters are most likely in the queries that drive the report. If you want to display the sum of 2 text boxes on your report or something similar then create a third textbox with: =mytext1+mytext2

I don't like embedding my parameters in my queries if I can get away with it. Normally I drive my reports from a form and the end-user enters or selects the parameter values. You can use the Expression Builder to help define the criteria in the reports datasource.

[Missionary]

Thanks for the tip on using a form for parameters. My query doesn't have any parameters anymore, but the report still asks for those first values every time I preview it. Even f I change the report's data source to a different query, it still asks for them. I really don't want to make my report all over again. How can I get rid of those report parameters?
Thanks a ton.

Missionary

The parameters are most likely in the queries that drive the report. If you want to display the sum of 2 text boxes on your report or something similar then create a third textbox with: =mytext1+mytext2

I don't like embedding my parameters in my queries if I can get away with it. Normally I drive my reports from a form and the end-user enters or selects the parameter values. You can use the Expression Builder to help define the criteria in the reports datasource.

[jaxjagfan]

Thanks for the tip on using a form for parameters. My query doesn't have any parameters anymore, but the report still asks for those first values every time I preview it. Even f I change the report's data source to a different query, it still asks for them. I really don't want to make my report all over again. How can I get rid of those report parameters?
Thanks a ton.

Missionary

Just some thoughts ...
Do you have textboxes or other controls that are bound to fields that don't exist?
Any subreports? Any groupings or subtotals that are asking for the parameters? Did you check the query parameter properties?

[Missionary]

Just some thoughts ...
Do you have textboxes or other controls that are bound to fields that don't exist?
Any subreports? Any groupings or subtotals that are asking for the parameters? Did you check the query parameter properties?

There are no controls bound to deleted fields
No Subreports.
I checked Query Parameters and there weren't any.

After some experimentation I was able to repeat the problem:
First you have a text box where the Control Source is something like the following:
=[Surname] & ", " & [Name]
where [Name] and [Surname] are fields in the source query.
Then you delete the fields from the query while the textbox is still in the report. Then, even if you delete the textbox, the report will still ask you for the parameters when you preview it.

I hope that helps. What can I do to get rid of them? I certainly apreciate your help.

-Missionary

[jaxjagfan]

There are no controls bound to deleted fields
No Subreports.
I checked Query Parameters and there weren't any.

After some experimentation I was able to repeat the problem:
First you have a text box where the Control Source is something like the following:
=[Surname] & ", " & [Name]
where [Name] and [Surname] are fields in the source query.
Then you delete the fields from the query while the textbox is still in the report. Then, even if you delete the textbox, the report will still ask you for the parameters when you preview it.

I hope that helps. What can I do to get rid of them? I certainly apreciate your help.

-Missionary

What about report groupings? If you create a group in the report and then delete the group in the query ot table you will get the prompts as well.

[Missionary]

What about report groupings? If you create a group in the report and then delete the group in the query ot table you will get the prompts as well.

Ah, you've hit that one on the head. I did use one of them as a grouping in the report, then deleted the textbox. How do I get rid of the grouping on my report?

I have a total of three "ghost" parameters. One that was the grouping, and two that I used in the "equation" that I talked about in my last post.

Now I guess we've identified the problem. We're getting there!

[Missionary]

I'm still struggling with this problem. Any ideas on how to get rid of these parameters?

[jaxjagfan]

I'm still struggling with this problem. Any ideas on how to get rid of these parameters?

Make sure you get rid of the group in the report as well as the "groupings". It doesn't give you the ability to delete those just clear the entry so it is blank. Check any formulas and subtotals as well.