Solved

Crystal reports doesnt' show date field

Posted on 2010-09-17
4
822 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
4 Comments
 
LVL 19

Expert Comment

by:GJParker
Comment Utility
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 100

Expert Comment

by:mlmcc
Comment Utility
Do you simply see a blank or do you see #####?

Are there supposed to be dates in the fields?

mlmcc
0
 
LVL 34

Expert Comment

by:James0628
Comment Utility
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
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

762 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now