• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 997
  • Last Modified:

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
0
alayanna
Asked:
alayanna
  • 2
1 Solution
 
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now