Solved

Crystal reports doesnt' show date field

Posted on 2010-09-17
4
884 Views
Last Modified: 2012-05-10
I'm using Crystal Reports 2008 Ver 12.2.0.290 the full version not the Visual Studio one.
In two separates reports I have sofe fields date, fields string, number...
In some machines all work well but in others the date or time fiels doesn't appear.
If I try to export to excel PDF the same and if I print the same.

Any idea?
0
Comment
Question by:cpx_Support
[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
4 Comments
 
LVL 19

Expert Comment

by:GJParker
ID: 33700697
How are you viewing the reports on teh different machines ? do thet all hace CR 2008 installed or are you using some kind of viewer ?
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 33706084
Do you simply see a blank or do you see #####?

Are there supposed to be dates in the fields?

mlmcc
0
 
LVL 35

Expert Comment

by:James0628
ID: 33706930
What format did you use for those fields?  If you used "System Default Long Format" or " System Default Short Format", that may be the problem.  From the CR 10 Help:

 > When you choose System Default Long Format or System Default
 > Short Format, the program uses the time and date formats from the
 > Regional Settings Properties dialog box in the Windows Control Panel.

 If the format setting on some machines is different and doesn't fit in the field on the report, that might be the problem.  If the field format is one of the "system default" ones, try changing it to a specific format.  Or you could try checking, and if necessary changing, the Windows format setting on those machines.  Or you could try making the field longer, or turn on the "can grow" option in the field format.

 Even if the rest of this doesn't apply, that last option (make the field longer or use "can grow") might be useful, just as a general diagnostic tool.  If, for whatever reason, the problem is that the date/time doesn't fit in the field, that should allow you to see what that value is.

 James
0
 

Accepted Solution

by:
cpx_Support earned 0 total points
ID: 33786700
It is a bug from Crystal Reports:

Document Type "SAP Knowledge Base Article"
1392258 - Date time field is blank when using ADO .NET dataset and Crystal
Reports 2008, Service Pack 2.0
Language: English Version: 4 Validity: 18.08.2010 - active
Symptom
l Application using ADO .NET dataset is deployed using CR 2008 SP 2 runtime.
l The date time field provided in the dataset does not display on the report.
l The application works as expected on the development computer.
Reproducing the Issue
l Create a report that uses a date time field in Crystal Reports 2008, Service Pack
2
l Create an application in Visual Studio .NET that passes a dataset which contains
a date time field to the report.
l Deploy the application using the Crystal Reports msm or msi files.
l The report will not display the date time field.
Cause
l The issue has been submitted for a resolution.
l Tracking number is ADAPT01313677.
Resolution
The issue is resolved in Service Pack 2.3 for Crystal Reports 2008.
Keywords
dateTime
Header Data
Released on 18.08.2010 23:36:21
Release status Released to Customer
Component BOJ-DEV-NET
Priority Normal
Category Problem
Development Platform Visual Basic
Database ORACLE 10.2.0.4.0
Operating System WIN XP
References
Type ID Title
The table does not contain any entries
Product
Product Product Version
SAP Crystal Reports CRYSTAL REPORTS 2008 V1
0

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

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…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

690 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