cancel
Showing results for 
Search instead for 
Did you mean: 

Incorrect date display in crystal Report

former_member309127
Participant
0 Kudos

Hi,

When I drag and drop the date field from my service it shows an incorrect date on the report.

As shown in the screen shot image
How to overcome this issue? Even if I enter different parameter it shows the same incorrect date. It doesn't display date in database.

This question was asked previously but solution not provided. Check below link

https://answers.sap.com/questions/34852/index.html

Accepted Solutions (1)

Accepted Solutions (1)

former_member309127
Participant
0 Kudos

Dates are correct in .xml file.

The arrival date field was in my second sub-report.

I tried deleting the entire sub-report, resetting connection, verifying database, closing report and deleting the temporary files.

I created a new report only to display flight details and called that report in my main report as a sub-report.

I provided the sub-report link to main report and the original date which was there in database was visible in report.

By doing this the "junk" date value field problem was solved.

I think, crystal report saves some dummy data in it's cache.

I don't know the exact solution but this one worked out.

Well, Thank you Guys for helping me! Your advice is always helpful.

Answers (1)

Answers (1)

vitaly_izmaylov
Employee
Employee
0 Kudos

Report connects to webservice WSDL, so you should be able to open the wsdl in IE browser and get .xml file.

Can you check if the dates are correct in .xml file