Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: report returns previous line data Post Reply Post New Topic
Page  of 2 Next >>
Author Message
NCBeach4Me
Newbie
Newbie
Avatar

Joined: 28 Sep 2009
Location: United States
Online Status: Offline
Posts: 15
Quote NCBeach4Me Replybullet Topic: report returns previous line data
    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?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Jul 2010 at 10:47am

are you grouping?

are you joining tables?
IP IP Logged
NCBeach4Me
Newbie
Newbie
Avatar

Joined: 28 Sep 2009
Location: United States
Online Status: Offline
Posts: 15
Quote NCBeach4Me Replybullet Posted: 14 Jul 2010 at 10:49am
Nope.  Just one table.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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?
IP IP Logged
NCBeach4Me
Newbie
Newbie
Avatar

Joined: 28 Sep 2009
Location: United States
Online Status: Offline
Posts: 15
Quote NCBeach4Me Replybullet Posted: 14 Jul 2010 at 10:53am
All on one detail section.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Jul 2010 at 10:57am

no use of a formula field to replace the date fields

 



Edited by DBlank - 14 Jul 2010 at 10:59am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Jul 2010 at 10:59am

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

IP IP Logged
NCBeach4Me
Newbie
Newbie
Avatar

Joined: 28 Sep 2009
Location: United States
Online Status: Offline
Posts: 15
Quote NCBeach4Me Replybullet Posted: 14 Jul 2010 at 11:03am
I'll give it a try.  Thanks!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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
IP IP Logged
NCBeach4Me
Newbie
Newbie
Avatar

Joined: 28 Sep 2009
Location: United States
Online Status: Offline
Posts: 15
Quote NCBeach4Me Replybullet 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.
IP IP Logged
Page  of 2 Next >>
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.