Crystal Report Viewer Date Issue
I use Crystal report Viewer to show my report using the following code
Code:
Dim CRReport As CrystalDecisions.CrystalReports.Engine.ReportDocument
CRReport = New CrystalDecisions.CrystalReports.Engine.ReportDocument
CRReport.Load(reportpath & "report1.rpt", [Shared].OpenReportMethod.OpenReportByDefault)
CRReport.SetDatabaseLogon(dbuser, dbpass)
CRReport.RecordSelectionFormula = "{rpt.EntNo}=5"
CRReport.VerifyDatabase()
CRReport.Refresh()
Rpt.CrystalReportViewer1.ReportSource = CRReport
Rpt.CrystalReportViewer1.ShowGroupTreeButton = False
Rpt.CrystalReportViewer1.ShowGotoPageButton = True
Rpt.CrystalReportViewer1.DisplayGroupTree = False
Rpt.Show()
It Sounds good.
But the issues is Date field which shown in report is formated as dd-MM-yyyy in my crystal. But this not shown as if in report viewer it shows in mm/dd/yyyy.