How do I get 2 different Groups with same Data?

Hello.  I have created a report but when I add 2 groups with same field from 2 different tables, I am getting a blank report.
When I take out 1 of the 2 groups then, I do get the data on the report.  Then I switch the report back and I take out the other 1 of the 2 groups then, I do get the data on the report.  But when I have 2 groups then I am getting a blank report.  Please help.  Thanks
ReportsupportAbilityAsked:
Who is Participating?
 
ReportsupportAbilityAuthor Commented:
Resolved by making two separate reports.
0
 
mlmccCommented:
What do you mean 2 groups?

Are you displaying data from both tables?

mlmcc
0
 
ReportsupportAbilityAuthor Commented:
There is temp_service, temp_person, temp_bill tables.
There is also service, person, bill tables.

Then I added a group from the temp_person table called consumers.
Then I added a 2nd group from the person table called consumers.

With both of these groups added I am getting blank report.  If I delete either 1 of these groups then I do get the data on the report.
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
mlmccCommented:
Are the tables linked?

mlmcc
0
 
ReportsupportAbilityAuthor Commented:
Yes, tables are linked.
0
 
mlmccCommented:
On what fields are they linked?

Are the temp tables linked to the others with similar names?

mlmcc
0
 
ReportsupportAbilityAuthor Commented:
This is how they are linked:

ebill_person.parent_id to ebill_iservice.parent_id
ebill_iservice.parent_id to ebill_iclaim.ebill_iclaim_id
ebill_iclaim.parent_id to ebill_ibatch.ebill_ibatch_id
ebill_iclaim.ebill_person_id to person.person_id
ebill_iservice.contact_id to contact.contact_id

temp_iperson.parent_id to temp_iservice.parent_id
temp_iservice.parent_id to temp_iclaim.ebill_iclaim_id
temp_iclaim.parent_id to ebill_ibatch.ebill.ibatch_id
temp_iclaim.ebill_person_id to person.person_id
temp_iservice.contact_id to contact.contact_id

contact.coctact_type_id to contact_type.contact_type_id

person.person_id to collection.parent_id

collection.child_id to file_number.file_number_name
0
 
mlmccCommented:
You don't have the tables fully linked together so your query has multiple starting points and Crystal can't resolve the problem.

mlmcc
0
 
ReportsupportAbilityAuthor Commented:
Sorry.  That wasn't right.  This is how they are linked together:

FROM  temp_ebill_Iperson
INNER JOIN temp_ebill_Iservice ON temp_ebill_Iperson.parent_id=temp_ebill_Iservice.parent_id
INNER JOIN contact ON temp_ebill_Iservice.contact_id=contact.contact_id
INNER JOIN temp_ebill_Iclaim ON temp_ebill_Iservice.parent_id=temp_ebill_Iclaim.ebill_Iclaim_id
INNER JOIN ebill_Iservice ON contact.contact_id=ebill_Iservice.contact_id
INNER JOIN contact_type ON contact.contact_type_id=contact_type.contact_type_id
INNER JOIN ebill_Iperson ON ebill_Iservice.parent_id=ebill_Iperson.parent_id
INNER JOIN ebill_Ibatch ON temp_ebill_Iclaim.parent_id=ebill_Ibatch.ebill_Ibatch_id
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.