Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How do I get 2 different Groups with same Data?

Posted on 2009-02-17
9
Medium Priority
?
409 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
0
Comment
Question by:ReportsupportAbility
  • 5
  • 4
9 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 23661199
What do you mean 2 groups?

Are you displaying data from both tables?

mlmcc
0
 

Author Comment

by:ReportsupportAbility
ID: 23661814
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 23664241
Are the tables linked?

mlmcc
0
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 

Author Comment

by:ReportsupportAbility
ID: 23664401
Yes, tables are linked.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 23664624
On what fields are they linked?

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

mlmcc
0
 

Author Comment

by:ReportsupportAbility
ID: 23725309
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 23726530
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
 

Author Comment

by:ReportsupportAbility
ID: 23726706
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
 

Accepted Solution

by:
ReportsupportAbility earned 0 total points
ID: 24825845
Resolved by making two separate reports.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question