Skip to Content
0
Former Member
Jul 12, 2012 at 03:10 PM

Crystal reports Subreport grouping

94 Views

This Question is regarding crystal reports subreport groupin

I have around 10 subreports each report is linked with One table(which is also sub report).

have a look at my tables

Table1

EMPID EmpName EmpSal EmpDesg

1 srik 12222 sssss

2 sri 22222 aaaaa

3 sss 3333 dddd

Table2

EMPID Accontno BankName Bal

1 234444 HDFC 12

2 5555555 ABC 1

3 333333 jjj 1

Table3

EMPID PrevOrg Loc EXp

1 ssss Bang 2

2 ABC Cal 3

3 BCD HYd 5

I have 7 more tables with foreign key EMPID.Each Table I have designed as subreport.

Now I want to show my report in such a way that all EMPID 1 records at one place followed EMPID 2 records ....

Expected O/P:leave about headings

1 srik 12222 sssss(Table1)

1 234444 HDFC 12(Table2)

1 ssss Bang 2(Table3)

2 sri 22222 aaaaa (Table1)

2 5555555 ABC 1 (Table2)

2 BC Cal 3 (Table3)

3 sss 3333 dddd (Table1)

3 333333 jjj 1 (Table2)

3 BCD HYd 5 (Table3)

How to group the tables from different subreports in above format.

Thanks in advance.........