group total problem in dataitem indentation

monir_asian
monir_asian Member Posts: 80
edited 2012-05-06 in NAV Three Tier
i have data item indentation is as like following.

Purch. Inv. Header
--->Purch. Inv. Line

Report has a request filter field base invoice no. and group total on base invoice no for Purch. Inv. Header.



both table has a relation with document no= no.

purch.Inv.line also has group total by barcode.

Suppose I have
purch invoice header
No
base invoice no

P-PI_000698
PO_000737
P-PI_000696
PO_000737
P-PI_000697
PO_000737

purch invioce line
barcode
document no
type
custom
P-PI_000698
item(charge)
custom
P-PI_000697
item(chage)
011435345
P-PI_000696
Item

i need group by custom. but it is not in root data item.

it gives me 3 line because of data item indentation.

but correct output will be folloing
barcode
custom
011435345



what is the solution here?

Comments

  • thegunzo
    thegunzo Member Posts: 274
    When using group total fields you will also need to use the correct key (DataItemTableView) to make it work. Have you done that ?
    ________________________________
    Gunnar Gestsson
    Microsoft Certified IT Professional
    Dynamics NAV MVP
    http://www.dynamics.is
    http://Objects4NAV.com
  • monir_asian
    monir_asian Member Posts: 80
    yes, i have done this by using barcode no as a key and group total also by barcode.

    but root data item table is purch invoice header and data item indentation is purche invoice line.

    purch invoice header
    purch invoice line.

    so, it appears all record.

Categories