Date Parameter resetting

[icodian]

Hey guys,

On Crystal 8.5.

If more than one parameter is on a report and one of those is a Date Parameter, the date entered resets itself somehow.

For instance:
I first enter my Date Range Parameter: I select 01/01/04 - 01/31/04.
I then select the Customer parameter and choose customer ABC.

If I immediately run the report, it works perfectly. However, if I decide to go back and check my Date Range parameter to make sure I entered it properly, the dates reset to today's date. Running the report will give me no information, I must re-select the date for it to work properly.

Is this a bug? If so, is there a fix? Tell me it's not by design

Thanks for any help!

 

[bdreed35]

You can add your parameters to your report to view them. Drag them out of the Field Explorer and place it on your report.

If you hit the lightening bolt and choose "Prompt for new parameter values" then you will be entering new variables and the default values will show up in the dialog box.

~Brian

 

[icodian]

Thanks for the post.

I don't think I explained my situation clearly. Let me try to clarify.

When you are refreshing the parameter values, and you are at the "Enter Paramter Values" screen, select the Date Range field and enter the Start and End of the range. Then in the "Parameter Fields" at the top, select the second parameter and enter the value. Before pressing the OK button to refresh the report, click back up to the first Date Range parameter. The dates have been reset.

I've had a couple other guys around my office try this with the same result, so I'm guessing it is universal. Let me know if otherwise.

Thanks again.

 

[bdreed35]

Well, I am using Crystal 8.5 and my parameters are not getting reset when I perform the steps yous posted. Have you tried looking up the issue in the BO knowledge base? There may be a hot fix to correct this issue.

~Brian

 

[icodian]

Sure have. Couldn't find any results related to this issue. I wonder if it has something to do with software that we have installed such as MAS 90 or other reporting software. Perhaps a dll was replaced with a previous version or something. Hmmm...

 

[synapsevampire]

You didn't mention the actual steps that you're taking, rather a descriptive.

I suspect that your "However, if I decide to go back and check my Date Range parameter" means that you're selecting prompt for new values, which would reset the date prompt.

If you select Use Current Values, then the report will retain the old values.

-k

 

[icodian]

Yeah, tried to be more descriptive in my second post. See above. Thanks.

 

[synapsevampire]

Yeah, that's the way it works, when you state that you want to refresh parms, and then pop back into them, they reset.

In CE 85 if you had a datetime on XP as the first parm it would hang, there are lots of little gotchas.

<shrug>

Yours isn't a big issue, the date wasn't reset UNTIL you went back to it.

-k

 

[icodian]

I still must not be explaining it well... It actually resets without ever leaving the &quot;Enter Parameter Fields&quot; screen. Here is the specific sequence of steps (every mouse-click):

1. I am viewing the Report Preview and decide to enter new parameters.
2. Press F5 (Hit Refresh)
3. I am asked if I want to keep the Current values or Prompt for new ones. I select to be prompted for new values and press OK.
3. &quot;Enter Parameter Fields&quot; dialog box appears.
4. First parameter is called 'Date Range.' It is a Range Value, Date Parameter. I select the Start Date of the Range as 01/15/04. I select the End Date of the Date Range as 01/31/04.
5. I then select the second parameter at the top called 'Customer Name.' It is a Discrete Value, String Parameter. I enter ABC Company as the customer.
6. BEFORE pressing OK to refresh the report, I change my mind. Instead of running the report for dates 01/15/04 to 01/31/04, I decide to run it for the entire month. I want to change the Start Date to 01/01/04. I select the 'Date Range' parameter at the top to make the change. The Start Date and End Date now both say 02/03/04 (reset to today's date). I must re-select both dates again.
7. Press OK to refresh the report.

Does that make more sense?

 

[icodian]

Sidenotes:

After step 6 above, if I decided to select the 'Customer Name' field again BEFORE refreshing the report, the data (ABC Company) has been stored properly and not reset.

In fact, when I changed the Date Parameter to one that accepts Multiple Values, it stores the values properly and does not reset....

 

[vidru]

Looks like it only happens to range parameters (the resetting, thatis), wheter they're dates, strings, etc.

Bug, or &quot;feature&quot;.... you make the call!!!

-dave