Report Design woes!!

[stimguy123]

Hi there,
I need help before i quit my job or shoot myself.

Anyway, i need to display some information on a report but its not working out correctly.

I have 2 tables imported to my report.
the 1 st table lists organization (org) and order (ord)

so its in the format of

Table 1
org1 ord1
org1 ord2
org2 ord1
org2 ord2
org2 ord3

so i display this information in the report and supress the duplicate org's
so in the report it displays correctly.
eg.

org1
ord1
ord2

org2
ord1
ord2
ord3

so far im good. here comes the hard part. on the next table, i have 'people' which has a primary key link with the 1st table (org)
so the structure of table 2 is

org1 ppl1
org1 ppl2
org1 ppl3
org2 ppl1
org2 ppl2

so the number of records in these 2 tables may not be the same as you can see.

the issue now is that i want to display a report like this

org1
ord1
ord2
ppl1
ppl2
ppl3

org2
ord1
ord2
ord3
ppl1
ppl2

but its being displayed like this instead


org1
ord1
ppl1
ppl2
ppl3
ord2
ppl1
ppl2
ppl3

org2
ord1
ppl1
ppl2
ord2
ppl1
ppl2
ord3
ppl1
ppl2

the report has 2 sections and is formated as below

section a
org
ord

section b
ppl


help!!!

[stimguy123]

update.
i've tried using this under the supress condition for 'ppl'

whileprintingrecords;
if {Query_QA.org} = Next({Query_QA.org}) AND Not NextIsNull ({Query_QA.org}) then
true
else
false


this only partially works as only the last record of ppl is displayed and not all

[HairyMonkeyMan]

What type of database are you using and what programming language?

I hate crystal reports and normally try to do as little processing as possible inside the actual report. I as much as possible to organise my data in the database or my program before going to the report.

[stimguy123]

im starting to feel the same sentiments.
using vb.net 2005 with crystal reports built in.
its an MS access datafile

[stimguy123]

im starting to feel the same sentiments.
using vb.net 2005 with crystal reports built in.
its an MS access datafile