Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Pulling different info from 2 fields Post Reply Post New Topic
<< Prev Page  of 3
Author Message
KevV
Senior Member
Senior Member


Joined: 19 May 2011
Online Status: Offline
Posts: 106
Quote KevV Replybullet Posted: 20 Sep 2012 at 9:15am
I did suppress all but the group footer and got just the one line. On the tables they are only joined by the id and the only select statement I have is a date range.
 
KevV
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 20 Sep 2012 at 9:22am
It still might be the combinataion of the join and the select statement.
you have to think it through or replicate the data set in sql and look at the data set int he raw there.
If you look in a table and the data is there but it is not in the data set for the report the most logical reason is your join and/or select statement has filtered it out.


Edited by DBlank - 20 Sep 2012 at 9:24am
IP IP Logged
KevV
Senior Member
Senior Member


Joined: 19 May 2011
Online Status: Offline
Posts: 106
Quote KevV Replybullet Posted: 20 Sep 2012 at 10:32am
If it were a join issue would it not cause the fields to be blank in all of the people and not just a few?
 
KevV
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 20 Sep 2012 at 10:34am
are the fields blank in the detail row or in your formula results?
IP IP Logged
KevV
Senior Member
Senior Member


Joined: 19 May 2011
Online Status: Offline
Posts: 106
Quote KevV Replybullet Posted: 20 Sep 2012 at 10:39am
In the formula results. I do not have anything in the detail row. It is all in the group footer. 
 
KevV


Edited by KevV - 20 Sep 2012 at 10:40am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 20 Sep 2012 at 10:41am
but is the 'raw' data in the data set as you expect it to be (which you can only see in the detail row).
Place the 'missing' raw fields in the details and see if it is in the data set.
You have to figure out if your formulas are wrong or the data set is wrong.


Edited by DBlank - 20 Sep 2012 at 10:42am
IP IP Logged
KevV
Senior Member
Senior Member


Joined: 19 May 2011
Online Status: Offline
Posts: 106
Quote KevV Replybullet Posted: 20 Sep 2012 at 12:01pm
I put it in there and I end up with around 25 to 30 rows for each person and the number shows sometimes but not always.
 
KevV
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 20 Sep 2012 at 12:03pm
if it is not what you expect to see then you have to fix your join or your select statement.
I do not know your data (tables) or the relationship between them so it is hard to trouble shoot this for you.
IP IP Logged
<< Prev Page  of 3
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.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.