Crystal Report XI Dynamic Parameter not Populating

I have two COMMAND queries in my report. The first query retrieves all the data for the report and has three parameters in the 'where clause'. The second query is for one of the parameter values to be populated dynamicly.

Now here is the problem. Two of the parameters in first query are date parameters so they don't have quotes around them (ie. column = {?P_START_DATE}). So when I'm prompted for the parameters when running the report the parameter that is to be populated by the second query is not being populated. Though I can type a value in for the second parameter and the report will run correctly.

But if I turn my date parameters in the first query to string values and put quotes around them (ie. column = to_date('{?P_START_DATE}', 'DD-MON-YYYY')), when running the report and prompted for parameter values the parameter populated by the second query populates correctly and gives me my Drop-Down.

So my assumption is that because of the unquoted parameter value in the first query it is causing a problem with the second query from running appropriately to populate its paramter value when prompted. Is there a work around for this issue or a method that i'm not incorporating for this to work appropriately. Because I would like to keep the parameters as dates for the pop-up calendar feature.

Thanks
LVL 1
alayannaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
I don't know why that would be an issue.  Does the second query rely on the date parameters?

mlmcc
0
alayannaAuthor Commented:
No. The date parameters in the first query have no relation to the second query being run.
0
mlmccCommented:
You can change the order of the prompts.
In design mode
Right click PARAMETERS in the field explorer
Click SET PARAMETER ORDER
Make the dynamic one first

mlmcc

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.