Crystal Reports 7 using wrong date format

Whenever one of my users prints any of our reports, the date is in dd/mm/yyyy format, when it should be in mm/dd/yyyy format. This might be more of a Windows settings issue rather than a CR7 issue, but it only seems to do this when a CR7 report is printed, anything else involving a date in any other software prints/displays correctly. I have checked the regional settings on their computer and they are all set properly. Uninstalling and reinstalling the CR7 runtime files didn't seem to help either.

Does anyone know if CR7 stores its own date formatting information? Thank you in advance.Use Field Formatting to set the format of the date. Else you can covert the date into a string also.

In case you need to pass date as a parameter, Crystal Reports allows you to pass the date in three pieces (Date, Month and Year).

Hope you will solve the problem.

Kangkan

<a href="http://links.10026.com/?link=http://www.geekays.net">geekays.net</a>sql

Crystal Report displays wrong value.

Hi,

There is a issue in VB & Crystal report version is 8.5.
I have got a report which displays wrong values though the values returned from the database is correct. It displays all the numbers by dividing 100 to it. I am getting correct values in some of the machines but not in rest. For eg if the value returned from the database is 80 then the report displays the value as 0.8 in some of the machines which is wrong. How do I correct this wierd error? Is there any system based setting where in I could go and change? We have checked the following things and it seems to be correct (DSN settings, Reports Versions)

Crystal report version is 8.5. In users m/c, no crystal report is installed.
Please tell me are there any settings to be set in user machines.

Reply asap.

Regards
Shilpai hope ur problem will be solved if u follow the instructions here...

1) Rt.Click on the Field.
2) choose "Format".
3) check which Style is selected in the "Number" Tab.
NOTE: if it is system default then change it according to ur requirement.

if u r using "Customize" then do following
1) Click on "Customize"
2) Click on "Currency Symbol" Tab.
3) Make sure "Use System Default Format" is Unchecked.
NOTE: if it is checked then make it Unchecked.
Mostly people sets the format according to thier need but
ignore this option which makes such type of troubles.

Hope will be helpfull........Cheer up :D|||Crystal report version is 8.5 .

I checked in the crystal reports on the
first step
1) Rt.Click on the Field.
2) choose "Format".
3) check which Style is selected in the "Number" Tab.
there is no system settings enabled.

Also I couldnt find option specified in the Currency Symbol tab...:

Please reply.

Regards
Shilpa|||Crystal report version is 8.5 .

I checked in the crystal reports on the
first step
1) Rt.Click on the Field.
2) choose "Format".
3) check which Style is selected in the "Number" Tab.
there is no system settings enabled.

Also I couldnt find option specified in the Currency Symbol tab...:

Please reply.

Regards
Shilpa

i think u did not follow the second step..

1) Rt.Click on the Field.
2) choose "Format".(from the pop up window)

you will see "Format Editor" window like in "1-Second Step"
then watch "2-Second Step" and "3-Second Step" respectively.|||i think u did not follow the second step..

1) Rt.Click on the Field.
2) choose "Format".(from the pop up window)

you will see "Format Editor" window like in "1-Second Step"
then watch "2-Second Step" and "3-Second Step" respectively.

I have followed the above steps. But there is no Use System Default format option in step 2 that is in Customize section. You can see images attached for this. I think the version which u have worked is different. Here version is 8.5. Please tell me if you know anything.|||I have followed the above steps. But there is no Use System Default format option in step 2 that is in Customize section. You can see images attached for this. I think the version which u have worked is different. Here version is 8.5. Please tell me if you know anything.

i m using Crystal Report 8.5 and the problem i was expecting is not in your case.

i got rid of the same situation by the steps i told u.|||U can also change the Number format of those systems to that one on which u getting the correct result by

Start->Settings->Control Panel->Regional Settings->Numbers (Tab)

Crystal Report Database Path question

VB 6 Enterprise Edition; Crystal Report XI Developer Edition

I don't understand, did I phrase my previous question wrong?

Let me restate it:

From a VB 6 application, how do you code to tell Crystal Reports where the database tables are located?

This is the code I use to get the report(s)
Set craxreport = craxapp.OpenReport(App.Path & "\" & ReportName)
craxreport.DiscardSavedData
CrystalActiveXReportViewer1.Refresh
CrystalActiveXReportViewer1.ReportSource = craxreport
CrystalActiveXReportViewer1.ViewReport
Set craxreport = Nothing
SamProblem Resolved:
Here is the code in case anyone needs it:

Dim dbTable As CRAXDDRT.DatabaseTable
Set dbTable = craxreport.Database.Tables(1)
craxreport.DiscardSavedData
dbTable.Location = App.Path & "\BOM.mdb"
CrystalActiveXReportViewer1.Refresh
Call CrystalActiveXReportViewer1_RefreshButtonClicked(True)
CrystalActiveXReportViewer1.ReportSource = craxreport
CrystalActiveXReportViewer1.ViewReport
Set craxreport = Nothing