Report

Sumathi

Hi Experts,
Plz help me out from this probs,
i need 2 group multiple fields ,with multiple table in a single report,
N number of grouping is possible while using single table in a
"report wizard",but multiple tables cant be declared in a wizard
will u plz help me imme..

i have explained it in detailed........
Table 1
Grp 1
Grp2
Table 2
Grp 1
Grp2

Table 2 Body

Table 2 Grp1 Footer
Table 2 Grp2 Footer
Footer

regards
Sumathi

sjan

When you have finished wizard with Table1 just add Table2 in ReportDesigner and put field you want on Sections.

Sumathi

Thanx sjan,
i have tried it,but the table 2 is indented into table 1 ,for grping,
both r linked by "document number".
can u give another tip to proceed the same
eg

Sale header - Table 1
Cust Num -Grp 1 Head
Terms Code -Grp 2 Head

Sale Line - Table 2
Item Num - Grp1 Head

Sale Line Grp Footer

i got the result but the sale Grp Footer is printing twice .

plz help me

regards
Sumathi

awarn

Use the arrow button to control the indent, or the DataItemIndent property.

i4tost

I'm not sure that understood you, but maybe you forgot to use function TOTALCAUSEDBY in the group header or footer?