Crystal Reports XI date prompts

I have created a report using Crystal Reports XI.  
It selects records from a Progress OE10 database based on a date field.
If I build the selection within the report I can select the date in month, day, year format.
What I mean is within the Selection Expert I select the field, select Is Greater Than, then enter the date as 08/01/10.
When I look at the formula it shows this:  {PV_SOrder1.SOrderDate} > Date (2010, 08, 01)

I want to change this to a prompt for the user so I created a prompt field called OpenDate and set the type as date.
The selectiion  forumula now looks like this:  {PV_SOrder1.SOrderDate} > {?OpenDate}

The problem is the prompt requires me to either select the date from a calendar or enter it as yyyy-mm-dd.
I want to enter it as mm/dd/yy.  I did not have this problem in previous verions of Crystal Reports.
Is there a way to accomplish this?
Suz_KCAsked:
Who is Participating?
 
PCIIainConnect With a Mentor Commented:
I think the answer to this is 'Depends how you want to approach it'.

You can prompt for a string parameter, and parse this in a formula to get the date yourself. (Has the advantage that you can accept empty parameters to give  a default value.)


Alternatively the date picker is defined as a javascript in
C:\Program Files\Common Files\Business Objects\3.0\crystalreportviewers11\prompting\js
and I believe that if you went through this, you could rewrite it to prompt for and parse out in a different style.

Finally, you could write a VB viewer and prompt for the parameters yourself, allowing you to choose the style of the date input from VB.
0
 
GJParkerConnect With a Mentor Commented:
1.  Make your parameter date (?Date1) a Text field, and specify that it is input as 'mm/dd/yyyy'
2.  Create a formula field (@Date2) that converts the text date (?Date1) to Date format:
         cdate ({?Date1})

This way you will ose the date picker though
0
 
Suz_KCAuthor Commented:
Thank you.  Technically your answers work; however, I must be dealing with picky users.
In CR X when they were prompted they had the option of entering the date in the format of mm/dd/yy or clicking on the calender.  In CR XI the date format is only yyyy/mm/dd or they can still click on the calendar.

If I follow your suggestion of changing the prompt to a string, the calendar selection goes away as an option.  The other suggestions of changing the java scrip and creating VB code worry because of future upgrades and compatibility with other applications.

I just wish Crystal Reports had an option you could set for the format of the selection date the same way they have for the way a date displays in reports.

Thanks for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.