Solved

Crystal reports doesnt' show date field

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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 …
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

920 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

15 Experts available now in Live!

Get 1:1 Help Now