Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
| Search | Today's Posts | Mark Forums Read
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old April 26th, 2004, 03:04 AM
Registered User
 
Join Date: Apr 2004
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Crystal Report Date Format

I have a crystal report that is displaying dates in a dd/mm/yyyy format. These display correctly in the Preview view. However, once I push them out through the crystal report viewer control on the web page, they revert back to mm/dd/yyyy.

Could anyone help me out? Thanks in advance.
Arun.

  #2 (permalink)  
Old May 4th, 2004, 01:57 AM
Registered User
 
Join Date: Feb 2004
Location: , , United Kingdom.
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I've put a support call in to Business Objects regarding this issue and i can honistely say they are crap, it looks like they only want to support Americanised dates.

1st Try setting all the dates via the custom mode, this should work except for the tree view.


My support call rose around the inconsitency in the data viewed in the tree.

2nd Look at HKEY_USERS\.DEFAULT\Control Panel\International\shortDate

key to the specific format

or

add RDC component (CRAXDRT.DLL) into a COM+ package and make it run under a User account.

HTH


  #3 (permalink)  
Old May 4th, 2004, 06:00 AM
Registered User
 
Join Date: Feb 2004
Location: , , United Kingdom.
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Found another way around the group tree function displaying the incorrect format if you group by dates.

Just go into the "Change Group" on the context menu and click the options tab.

Select the option for "use formula as group name" and use the
ToText ({tbl_XXXXXXXX.SpeciminDate},"dd-MMM-yyyy") or whatever format you wish.

Can't beleive their technical support couldn't give me this solution themselves.

Not starting to be much of a fan regarding Business Objects since they took over crystal.

Hope that solves all your problems.



Similar Threads
Thread Thread Starter Forum Replies Last Post
Crystal Report date format gfredrick85 Crystal Reports 1 March 3rd, 2008 03:47 PM
How to set default format for crystal report as RT shikha09 BOOK: Professional Crystal Reports for VS.NET 0 May 29th, 2007 01:23 AM
export crystal report in txt format mallick_kuet Crystal Reports 0 January 20th, 2007 02:35 AM
V V V Urgent::Crystal report format issue narayanark2003 Crystal Reports 0 July 6th, 2006 07:58 AM
show data in a tree view format in crystal report srithi Crystal Reports 1 February 22nd, 2006 12:33 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.