Skip to Content
0

How to handle garbage values in crystal reports?

Oct 18, 2016 at 08:34 AM

128

avatar image
Former Member

I have a field as FromDate in database which has a value 25-Dec-2016.
When I drag and drop the field in report, it shows me a garbage value as 1 Jan-4173.

How to handle this error? Can anyone suggest?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Abhilash Kumar
Oct 18, 2016 at 08:35 AM
0

Hi Sailee,

Which version of CR is this and what is the database?

Does the database show this field's type as 'Date'?

-Abhilash

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Database show 'FromDate' as DateTime.

SAP BusinessObjects CrystalReports 2013 Version 14.1.4.1327

For FromDate in Report it shows 1 Jan-4173 Junk value

0
Abhilash Kumar
Oct 18, 2016 at 08:49 AM
0

And which database are you reporting against?

Please post the driver you're using as well.

-Abhilash

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

And which database are you reporting against? - - -

I am using web service to connect report. Database Expert-> Create New Connection -> XML and Web Service-> Make new Connection-> Use web service Datasource -> use HTTP(S) WSDL URL-> ServiceName -> Port -> Method -> Finish.

This path I am using for database connectivity.

can you please tell even after reseting the connection why it is showing the garbage collection value in report? as my in my SQL Database, data is correct. Only report is displaying garbage collection value. i.e. 1 Jan-4173

0
Former Member

This is what displaying on report.

cr1.jpg (11.7 kB)
0