group total problem in dataitem indentation

monir_asian

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?

thegunzo

When using group total fields you will also need to use the correct key (DataItemTableView) to make it work. Have you done that ?

monir_asian

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.