Joined: 11 Mar 2008
Location: United Kingdom
Online Status: Offline
Posts: 2
Topic: Crystal Reports Date Posted: 11 Mar 2008 at 8:27am
Hi,
I am pretty new to Crystal Reports.
I am building a report which gets its data from a Stored Procedure.
Its all working except for one thing:
The DATES are coming up 'random' i.e. In the database the date says the 6th February, but it is being output as the 5th of February. It does it with all the dates and ranges from 1 - 5 days.
When I check the Stored Procedure in SQL Studio Express, it returns the correct date.
Has anyone had a problem with this before? If so, how did you fix it?
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 11 Mar 2008 at 10:50am
I haven't seen that before. Is the date format that SQL using non-standard or something different than the default?
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
