Report

Sumathi
Sumathi Member Posts: 24
edited 2004-07-23 in Navision Attain
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

Comments

  • sjan
    sjan Member Posts: 16
    When you have finished wizard with Table1 just add Table2 in ReportDesigner and put field you want on Sections.
  • Sumathi
    Sumathi Member Posts: 24
    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
    awarn Member Posts: 261
    Use the arrow button to control the indent, or the DataItemIndent property.
  • i4tost
    i4tost Member Posts: 208
    I'm not sure that understood you, but maybe you forgot to use function TOTALCAUSEDBY in the group header or footer?

Categories