Print Page | Close Window

report returns previous line data

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10533
Printed Date: 28 Apr 2024 at 12:19am


Topic: report returns previous line data
Posted By: NCBeach4Me
Subject: report returns previous line data
Date Posted: 14 Jul 2010 at 10:43am
I have a simple report running from live data (not a view or reports server table).  Everything in the report is correct except two date fields I'm pulling.  Weird thing is...they return the date fields from the record above the line of the actual record in the data.
 
For example:
 
Name............Address.........Transfer Date........Begin Date
Joe Fox.........123 Main St....04112010.............05122011
Jane Doe.......245 Cox St....08152010.............09222010
 
So in my report, Jane Doe is returning everything correctly but the dates are those of Joe Fox.
 
Any suggestions?


Replies:
Posted By: DBlank
Date Posted: 14 Jul 2010 at 10:47am

are you grouping?

are you joining tables?

Posted By: NCBeach4Me
Date Posted: 14 Jul 2010 at 10:49am
Nope.  Just one table.

Posted By: DBlank
Date Posted: 14 Jul 2010 at 10:51am
are you grouping data and dsiplaying on headers or footers or is this all on one detail section?

Posted By: NCBeach4Me
Date Posted: 14 Jul 2010 at 10:53am
All on one detail section.

Posted By: DBlank
Date Posted: 14 Jul 2010 at 10:57am

no use of a formula field to replace the date fields

 

Posted By: DBlank
Date Posted: 14 Jul 2010 at 10:59am

or a formula in the 'display string' option in the format properties?

Posted By: NCBeach4Me
Date Posted: 14 Jul 2010 at 11:03am
I'll give it a try.  Thanks!

Posted By: DBlank
Date Posted: 14 Jul 2010 at 11:22am
Was asking if either of those were used...
 
If you can drag and place these fields from the table onto one detail line and the dates are 'wrong' then your data is 'wrong' in the actual table, not just the report.
How are you determining that the displayed dates are wrong

Posted By: NCBeach4Me
Date Posted: 15 Jul 2010 at 2:12am
I can click and drag them.
I ran the report then looked several different records to verify the dates for each of them.  In each case they were pulling the dates on the line above their respective record.

Posted By: DBlank
Date Posted: 15 Jul 2010 at 4:06am
How are you knowing that it is the 'wrong dates'? From looking at the data in its source table? or looking in a GUI interface that shows dates?
 
I have never heard of this issue in Crystal and the more likely problem is that the data in the source is 'wrong'.

Posted By: NCBeach4Me
Date Posted: 15 Jul 2010 at 4:10am
The data I'm looking at is the .txt file which is loaded into our system.  So the issue may very well lie within our system.  Something may be happening to it once it's loaded.  I'm basically trying to prove that point.  The original data is date only.  When I try to pull this field in Crystal, from the system (after it's been loaded), the field is date and time.  So something is happening somewhere.  I'm beginning to think it's not necessarily my report.

Posted By: DBlank
Date Posted: 15 Jul 2010 at 4:36am
I would agree that it is not the report. What you are doing in the report is too straight forward and it is showing you an issue with the source for the report.
I would say there is an issue with the txt file itself or the import from the txt file into whatever the system you are using.


Print Page | Close Window