Dataset Tables Not Linking
Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
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=4522
Printed Date: 18 Apr 2025 at 9:45pm
Topic: Dataset Tables Not Linking
Posted By: BernieHunt
Subject: Dataset Tables Not Linking
Date Posted: 13 Oct 2008 at 11:17pm
|
I have a report that links to a dataset that has two tables. One is patient demographic data and the other bills for the patients. Both tables have a field called PatientID that links them together.
The report is set to group by the patient's last name. The data sources is set to link the two tables with an outer join enforced both ways on the PatientID.
When the report is displayed, it does not more to a new group when two patients have the same last name. I have verified this by displaying the PatientID filed in the details section.
Any suggestions on what I'm doing wrong?
Thanks,
Bernie
|
Replies:
Posted By: BrianBischof
Date Posted: 14 Oct 2008 at 10:13am
|
Since you are grouping on last name, then the report won't look at the first name and thus won't break them apart. Why aren't you grouping by Patient ID? You can still sort by last name by going into the Group Options dialog box. ------------- Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a> |
Posted By: BernieHunt
Date Posted: 14 Oct 2008 at 3:22pm
|
Originally posted by BrianBischof
Why aren't you grouping by Patient ID? I don't honestly know, hahahaha. This is some code from 3 or 4 years ago that used to work. I suspect the fields got changed along the way and nobody noticed. I had to use some fancy footwork to copy and paste the fields an formating into the new grouping, but it looks like all is well.
Thanks for helping me out Brian. I was trying to out think Crystal and figure new record equals new group. I guess that's way friends don't let friend code when they are tired.
BTW, great books!
Bernie
|
Posted By: BrianBischof
Date Posted: 14 Oct 2008 at 4:04pm
|
Haha, I've done similar things. You try to make a square peg fit into a round hole and forget that the round peg would be much better.
 Glad you like the books! I just approved the final proofs for http://www.amazon.com/exec/obidos/ASIN/097495361X/bischofsystem-20 - CR.NET 2008 book and it should be in the bookstores in a few weeks.
 You can find out more about my books at http://www.amazon.com/exec/obidos/ASIN/0974953601/bischofsystem-20 - Amazon.com or reading the http://members.crystalreportsbook.com - Crystal Reports eBooks online. ------------- Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a> |