Trying to add the "parameter" values of a report to the report header...

[KingOf206]

Ok, So I am Trying to add the "parameter" values of a report to the report header... I am able to do it, however, when I did it the way I thought should work I am asked to enter the parameter values TWICE. It is asking me for the "Enter the Start Date" box twice. And the 2nd box is the one that actually appears on the report.



How Can I get past this to only ask me the parameter values 1 time and then will show the parameter values on the report header?

This shows my report in design view



This one shows the order of the Search Parameters that it asks me (it should only ask me 3 of those questions, not 4)





Here is the Query that this report is based off of



How can I get this report to only ask me the parameter values 1 time?

[June7]

Possibly because one has more characters than the other. Looks like an additional space in the second Start Date prompt string after the colon.

I would not use popups for this dynamic user input. Cannot validate the entry resulting in much frustration for users. I NEVER use dynamic parameterized queries.

Have users input parameters on a form where validation can be managed. Then report would reference the form controls. Apply filter criteria when report is opened using WHERE CONDITION argument of OpenReport method.

Review http://www.allenbrowne.com/ser-62.html

[KingOf206]

I have other reports in which I do this a very similar way and it only shows up once, like normal. IS there a way i could still use this and it only show up once? I honestly am not quite sure what you are asking me. I am sorry, I wish I knew more....

[June7]

Did you check the strings? Are they exactly the same? As noted, looks like an additional space after colon in the second Start Date prompt.

[KingOf206]

yes that was it! I renamed the "Strings" and ensured they match. Now it only asks 1 time.

June7... You are the WHOA-Man!! Lol See I remembered!

Case CLOSED