Solved

Cyrstal Reports 2008 seeing SQL Server DATE field as STRING

Posted on 2014-04-24
15
1,348 Views
Last Modified: 2014-04-24
I have a crystal report that in 2008 see's the DATE field as a STRING. However, if I open the report using Crystal report 11.5 it shows it correctly as a DATE Field.

Our server version is 2008 which is why i need to get this fixed and my formulas are not working since it now sees as STRING.

Any ideas?
0
Comment
Question by:kelsanit
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
  • 4
  • +1
15 Comments
 
LVL 5

Expert Comment

by:mebaby333
ID: 40021183
did you try just formating the field as a date? right click on the box and choose format
0
 
LVL 5

Expert Comment

by:mebaby333
ID: 40021185
Or is there something in particular you are trying to do to it that is being prevented?
0
 
LVL 18

Expert Comment

by:vasto
ID: 40021187
Verify the database
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 

Author Comment

by:kelsanit
ID: 40021193
yes, I have verified the database.  I have even created a brand new report on the 2008 version with just that one table and it shows as STRING.  

I dont want to format as then it want work in the 11.5 version.

there has to be a setting in the options or just service pack fix for this. Currently on 12.4.0.966
0
 
LVL 18

Expert Comment

by:vasto
ID: 40021197
Are you using a view or stored procedure ?
0
 
LVL 5

Expert Comment

by:mebaby333
ID: 40021198
Did you try and confirm it would not work right in the 11.5 version?
0
 

Author Comment

by:kelsanit
ID: 40021211
I am using ODBC SQL driver and connecting directly to table.  No I did not verify it woudl not work in 11.5 if I format the field.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 40021216
What version of Crystal was the report built in?

Try opening it is CR XI then saving to a NEW report name

mlmcc
0
 
LVL 18

Expert Comment

by:vasto
ID: 40021220
when you verify the database the report will detect that the field is different and will ask you to map it to another field. Did you see anything like this ?
0
 

Author Comment

by:kelsanit
ID: 40021228
yes, when I open in 2008 it has be map. Of coure it does not find as same type and I have to map to string field.
0
 
LVL 18

Expert Comment

by:vasto
ID: 40021249
When you see the map button you should uncheck the check box for the type. Then you will see the date field. If you map the field to a string field it will assume it is string
0
 
LVL 5

Expert Comment

by:mebaby333
ID: 40021252
change the  ODBC connection  to SQL SERVER NATIVE CLIENT 10.
0
 
LVL 5

Expert Comment

by:mebaby333
ID: 40021256
The new SQL Server connection type is an updated driver that older versions of Crystal Reports do not recognize
0
 

Author Comment

by:kelsanit
ID: 40021262
currently i only see SQL Server as an option on the server.

how do i get option for NATIVE SQL server client?
0
 
LVL 5

Accepted Solution

by:
mebaby333 earned 500 total points
ID: 40021286
It is in the sql 2008 feature pack..... you can download it if you do not have the disk here..
http://www.microsoft.com/en-us/download/confirmation.aspx?id=16978

here is a technet article on installing it
http://technet.microsoft.com/en-us/library/ms131321%28v=sql.105%29
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question