Greetings,
This is driving me loony!!!
I have a report where I had changed the record source to a new query. Problem is when I run the report a prompt… “Enter Parameter Value” appears asking for a value. I checked everywhere in my report for the parameter it asks for. (A field that was in the old record source but not in the new one). I even looked in my query that is my new record source. But alas, I can not find it.
How can I remove this prompt?
The report runs fine when I hit the enter key with nothing in the dialog box as well as when I enter something into it. In other words, it does not matter what I enter into this dialog box, the report still runs OK.
Any help will be greatly appreciated.
Regards,
Bruce V. …aka…OASys1
And the Winner is… Jon Carter…
I had changed data sources and the problem (as Jon suggested) was in the sort part.
I clicked on the Group & Sorting… Clicked on the expression in the Sorting part. What do ya know… there was the rascal!
Just like a roach that hides under your silverware… and it’s just too fast for you to smash it. But I got this roach!
As soon as I changed the sort criteria from expression to an actual field in my query for that report, it worked.
One funny thing was that when I ran the query outside of the report, it worked! When I took the query out of the data property of my report and left it blank, my report worked, even though it had blank data field, but now that I had changed the sort def of the report (by clicking on Grouping & Sorting), my report runs fine.
But… Thanks to everyone that sent their ideas, even if they did not actually do the trick in my particular case, I am going to keep them all in mind, so your efforts to send me your ideas are actually useful.
Kind regards,
Bruce V. … aka… OASys1
Hi Bruce,
The old Parameter is possibly in the Grouping and Sorting part of the report.
I have found that the sorting tends not to get changed when I change data sources.
Regards,
Jon Carter
If this is a web application that displays the report in a browser, it is possible that the actual page that displays the report needs a URL parameter to be passed to it from the page where you run the report. Alternatively get rid of the URL variables and instead use form Variables instead. That way you will pass the parameter to the results page in the body of the form and not via the URL of the results page.
Thanks.
