Suz_KC
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.