Grouping
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=8710
Printed Date: 29 Apr 2024 at 5:57am
Topic: Grouping
Posted By: JeffHan
Subject: Grouping
Date Posted: 22 Dec 2009 at 9:05am
|
I am using three databases 1 Oracle and 2 Excel. They are linked together and the order is set. I preview the report and the total of the data is on the penny with another report. I then insert two groups and lose 5 records. Any clu ------------- JeffH |
Replies:
Posted By: DBlank
Date Posted: 22 Dec 2009 at 12:26pm
| when you grouped did this introduce a field from any of the 3 tables for the first time into the report or did all 3 tables have a value in the report already? |
Posted By: JeffHan
Date Posted: 22 Dec 2009 at 12:30pm
|
Thank you, you've given me something to think about. I would say generally know, but I will revisit that issue. ------------- JeffH |
Posted By: DBlank
Date Posted: 22 Dec 2009 at 12:41pm
|
in crystal the joins are not enforced (unless you explicitly make them so) until a field from the table is used. Since you cannot left join with excel you may be dropping records when you use a field from any source for the first time.
It is quite odd to watch a report jump from a million records to 0 just by adding a field to it (i just did that about 5 minutes ago because my join was on the wrong field)
 |
Posted By: JeffHan
Date Posted: 22 Dec 2009 at 12:46pm
|
Thanks again, I have a little more "learning" to do about joins, but I thought it might have to do with that. ------------- JeffH |
Posted By: JeffHan
Date Posted: 24 Dec 2009 at 12:27pm
|
Thanks for your help. I discovered that I was missing records in my two excel files, so that when a lookup failed for a field then it eliminated the record. I think that's what you were saying previously. Thanks again. ------------- JeffH |