Solved

Crystal reports doesnt' show date field

Posted on 2010-09-17
4
840 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
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 100

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 34

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

823 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