Crystal Report -Grouping problem

[cRitu]

Hi All,

We are designing crystal report using ADO.net Push method ,
here we are facing problem in groupinmg records,

below is our requirement description:

There is a master table Parent with primary key P and a child table Child with primary key C. Child in turn has 2 child tables ChildA and ChildB with primary keys CA and CB respectively. The report format expected is as follows:

Parent details
Child id (C1)
ChildA
detailsA1
detailsA2
detailsA3

ChildB
detailsB1
detailsB2
detailsB3
Child id (C2)
ChildA
detailsA1
detailsA2
detailsA3
ChildB
detailsB1
detailsB2
detailsB3
so on.....

Please help us find a way out to format our crystal report in the above fashion.
Thanks.
Ritu.

 

[synapsevampire]

You might want to post this in the Crystal Integrate forum.

Group on:

Parent
Child

Sort on:

ChildA
ChildB

Place the fields in the detail.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[cRitu]

Thnaks K!!

How to sort (Is it different from grouping??)
Pl. help

 

[synapsevampire]

Sort under Report->Sort Records.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com