Print Page | Close Window

Report Design woes!!

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4994
Printed Date: 04 May 2025 at 4:22am


Topic: Report Design woes!!
Posted By: damien5119
Subject: Report Design woes!!
Date Posted: 12 Dec 2008 at 1:00am
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!!!


Replies:
Posted By: damien5119
Date Posted: 12 Dec 2008 at 1:54am
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


Print Page | Close Window