cancel
Showing results for 
Search instead for 
Did you mean: 

Parameter Prompt, additional line being displayed

Former Member
0 Kudos

When viewing report in Crystal Report XI, which was developed in earlier version of Crystal Report, an additional Parameter Prompt Text is displayed. Then opening report in version of Crystal report developed in text is gone.

In Crystal Report XI Prompt Text is displayed as:

Enter desired Ending Cleared Date for report display:

Please enter date in format u201Cyyy-mm-ddu201D

In Crystal Report 8.t Prompt Text is displayed as:

Enter desired Ending Cleared Date for report display:

Where is this text coming from, and how can it be removed?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello,

Since the format for entering a date formula can vary so much Crystal will, by default and by design, show the user how the parameter values is expected. This is to precent confusion and irritation on the end users. There is no way to remove it, but it only shows in date and date time paremeters.

-Sean

Former Member
0 Kudos

Because this is a date field, the report is looking for data formatted as: MM-DD-YYYY

But the Prompt is:

Enter desired Ending Cleared Date for report display:

Please enter date in format u201Cyyyy-mm-ddu201D

This is really confusing our end users. When they manually enter the data as the prompt is telling them (yyyy-mm-dd), they get a bad date error message.

Is there a way to make this extra line of prompt text match the date format needed by the report?

Edited by: Barbara Miller on Jul 16, 2008 12:03 AM

former_member260594
Active Contributor
0 Kudos

That date format is hard coded into the parameter dialogue box.

You could create a string paramater where the user can enter the date in the format you want. If the parameter is used in record selection it can be converted to a date using the date function in the record selection formula

Answers (0)