We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

How do I get 2 different Groups with same Data?

Medium Priority
422 Views
Last Modified: 2012-06-27
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
Comment
Watch Question

Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
What do you mean 2 groups?

Are you displaying data from both tables?

mlmcc
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.
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Are the tables linked?

mlmcc
Yes, tables are linked.
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
On what fields are they linked?

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

mlmcc
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
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
You don't have the tables fully linked together so your query has multiple starting points and Crystal can't resolve the problem.

mlmcc
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
Resolved by making two separate reports.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.