Date field type Issue

[rubberhead10]

I have two windows xp sp 3 machines both running crystal reports 11. When I open the same exact report on both of the machines and browse to one of the date fields. One of the machines will prompt you to fix the report up then show the date as an actual date and the other will not ask to fix up the report and show it as a number. I have been scratching my head on the for a few weeks now and have not been able to figure it out and its causing a big issue because 90% of the reports are date driven half work the other half not......thanks for any help

pervasive database
crystal reports 11
both machines win xp sp3

 

[kray4660]

It is interesting to note that browsing the data shows the field as a number, not a date. It is possible that the Crystal Reports is configured differently on the two machines. I would double check the settings for the field types (File - Options - Fields).

Thanks.

 

[rubberhead10]

Thanks, I checked on both systems and the options fields settings are both the same, set to system defaults. I actually changed them just to see if it made any difference, but it did not. oddly I believe it to be something system related, I installed a program called datalink viewer and had the same issue when running the reports

 

[SkipVought]

hi,

Dates are NUMBERS, just as you see in your second example.

However, your NUMBERS have not been FORMATTED to DISPLAY Date/Time in some specified format.

The first indicates Type: Date

The latter indicates Type: Number

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[rubberhead10]

that is my issue......the report displays the birth date field as a date when ran on one system but displays as a number on another system. if the problem was localized to a single machine I would just blow it off but its about 50-50 on how it displays and its not just this one report it is any report that has a date field.......Thanks

 

[SkipVought]

Can you not change the Type?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[rubberhead10]

I do not believe so, the database is a pervasive database and it uses ddf files to get the field definitions. this is why I am so confused because it is looking at the same ddf file you would think it would be the same.......

 

[kray4660]

Is there some chance that the driver (ODBC?) is not the same on both machines? It is a long shot, but it is the only thing I can think of.

 

[rubberhead10]

I just went and looked at the obdc drivers and all the versions are the exact same on both machines

 

[SkipVought]

Looks to me like your example is in PREVIEW.

What about selecting DESIGN?

Your probelm is NOT the ODBC Driver!!! It's the FORMAT of this column/field. Seems to me that the format could be manipulated in DESIGN.

Just my 2cents as an outside observer.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[rubberhead10]

This might Help resolve this issue, on the one machine that show the birthdate as an actual date the following screen shots come up wanting you to fix up the database

you have to deselect the match type to be able to map it again....if I am not mistaken pervasive get its database field type from a file in the database called, in my case field.ddf
Thanks everyone for your help on this

 

[BettyJ]

I believe the database field has been changed since you created the report. You have to somehow force to refresh the database. In the particular machine, select Database Expert and right click on the Database name; if you see an option to Refresh, you can try that and see if it works.