473,322 Members | 1,314 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Date formating in Crysta Reports (VB.NET)

KK
Hi,

I am displaying a crystal report based on XML data
In XML I will get the date in this format.

<DOB>1946-05-22T00:00:00.0000000-04:00</DOB>
<EDIT_DATE>9999-09-09T00:00:00.0000000-04:00</EDIT_DATE>
<EFFDT>2002-08-01T00:00:00.0000000-04:00</EFFDT>

The code for generating report is

Private Sub generateRecapRpt()
Dim filePath As String
filePath = "test.xml"
Dim DSErrors As New DataSet("Errors")
DSErrors.ReadXml(filePath)
Dim rpt As New ErrorsRpt
rpt.SetDataSource(DSErrors)

CrystalReportViewer1.ReportSource = rpt
CrystalReportViewer1.Show()
End Sub

In ErrorsRpt.rpt, I am displaying the fields as it is. Please advise
how to format the date. I need the date to be displayed as 08-13-2002
02:35:45 (2002-08-13T02:35:45.0000000-04:00).
Thanks.

Nov 21 '05 #1
0 832

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: B. Harwood | last post by:
I am researching the value of purchasing Crystal Reports 9 over using the version of Crystal included with Visual Studio. I am currenly using Visual Studio.NET with C#, writing web applications,...
0
by: Stefanos | last post by:
Hi, I am using VS .NET 2003 and the included Crystal Reports .NET. I have built a windows form that displays a grouping report using the report viewer. I would like the end-user to be able to...
2
by: Jeannette | last post by:
Hi! there, I am currently working on web-based reports using crystal reports.NET 2003 and I am new to this reporting tool. I notice that the WEB forms report viewer toolbar does not include the...
2
by: cgia | last post by:
I see that VS.NET comes with Crystal Reports .NET, officially "The" reporting tool for .NET . But, when trying to use it, it works only in the local machine, not with a remote webserver. Wherever...
0
by: Sunil Sabir | last post by:
Dear All, I am actually quite new to Crystal Reports.Net. I am using Crystal Reports Viewer Control to display the report.But the problem is that my report is not displayed in the middle of...
0
by: test | last post by:
Where could I find an asp.net web host that supports crystal reports.net? Do I need to deploy each reference, or are there hosts with crystal reports.net preinstalled?
2
by: kumarujjwal | last post by:
if any of you have license key of Cryatal Reports .net that come with VS .Net 2003, plz mail.
1
by: ngpost1 | last post by:
I have a Crystal Reports.Net report being generated from my C# application. I would like to change the background color of the details section (not the text mind you) of the report on certain...
0
by: p.strong | last post by:
Gday, I am trying to deploy a windows forms application that uses crystal reports for .net 2005... Prior to publishing the application to a webserver, I have checked the prerequisite to...
0
by: tommaso.paxia | last post by:
hi guys, I have an application on .net framework 1.1 that uses crystal reports .net (version 9)... now I wanted to install it on windows vista... No way! First problem I can't install MSDE... ok I...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.