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