Solved

Crystal reports doesnt' show date field

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
C# Crystal Reports 15 101
Crystal Reports 7 VB6  'Feature Not Enabled' Error 10 31
Crystal Reports - help with converting time in a formula 4 19
Page Break on Change of Field 2 27
Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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 …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

733 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