Hi,
Can somebody please help me finding a solution ?
Here is the Problem:
Environment Details DEV:
BOXI 3.1product version 12.1.0.882
Crystal Reports 2008
DB2 database.
Environment Details UAT BOX
BOXI 3.1product version 12.2.0.290
Crystal Reports 2008
DB2 database.
ISSUE Desc:
1. I have designed a crystal reports in whih I have two parameters of type string.
2. We are using this field to take inpuit from the user as a date field i.e. stardate and enddate in dd/mm/yyyy format (because Crystal default format is mm/dd/yyyy)
3. converting this string in crystal to date type using Date() function.
4. We are retrieving the records between startdate and enddate.
5. This reports works as per our expectation in Crystal Report and on our DEV BOXI. i.e viewing and scheduling from CMC works fine.
But doesnt on our UAT BOX.
1. Report viewing from CMC works but when we are scheduling the reports for same date the instance success but they show report without data. There is no error while scheduling.
2. Now, If I open the instance and try to reenter the startdate and enddate again having same date, then the instance show me the data.
the dd/mm/yyyy format is working while viewing on UAT but mm/dd/yyyy format is working for scheduling.
I am not able to understand why this is happening.
Can any SAP member help me out please.
Regards,
Jon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.