Skip to Content
0
Former Member
Jun 07, 2011 at 06:44 AM

Crystal Reports 2008 and BOXI3.1 issue

10 Views

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