Grouping in Reports Builder 1

[sitadba]

I am creating a report that needs 3 sections.

For each airline ,I need to show the contacts & their information and then the airports the airline is operating.

AA American Airline
Contact Information
Marie Smith 555-1212 123 Main St
John Doe 765-4321 456 South St
Mary Jones 756-8483 123 Main St
Sites
JFK John F Kennedy Airport
LAX Los Angelas Int'l Airport
HKG Hong Kong Airport

This would repeat for each airline. The problem is that the contact information is repeating for each airport. I don't want any information repeating for each airline.

Any help is appreciated.

Thanks.
Denise

 

[haste]

Are u using different groups for the three sections?

Also, it would help if u described tables used and what fields u use to link the groups.

 

[sitadba]

Thank you. Here are our tables. I want it grouped just by airline.

AIRLINE_TBL
pk_airline varchar2 primary key
airline_desc varchar2

USER_TBL
pk_userid varchar2 primary key
first_name varchar2
last_name varchar2\
title
phone
email
address_1
address_2
address_3
address_4

USER_AIRLINE_TBL
fk_userid foreign key to USER_TBL
fk_airline foreign key to AIRLINE_TBL

AIRPORT_TBL
pk_airport varchar2 primary key
airport_name varchar2

AIRPORT_AIRLINE_TBL
fk_airport foreign key to AIRPORT_TBL
fk_airline foreign key to AIRLINE_TBL


Thank you for your help.
Denise

 

[haste]

What is the query u use in the repeating group handling contact info?

 

[nagornyi]

To avoid repeating personal info you need to create 3 queries, not one.
The main query would be for airlines. The details queries would be for contacts and for sites. So it will be one master query in the data model with two detail queries linked to the master query by appropriae fields.
In the layout model you will need one outer repeating frame for the airline query group. Inside that there should be two repeating frames one above another for contact and for site query groups.
This report can not be created with Wizard. The Wizard uses single query and puts Site frame inside Contacts frame, that's why they are repeated.

 

[sitadba]

Thank you very much. I will give this a try. I appreciate your help.

 

[sitadba]

This was EXACTLY what I needed. Thank you Nagornyi!