Group master + group detail- HOW TO
Hello,
imagine following data structure for Master and Detail:
MASTER: some column has some rows with same value(order number for example) like following
KIA
KIA
AUDI
AUDI
BMW
DETAIL: each detail has same structure
Detail rows for 1st KIA row in Master:
PRICE 10
WEIGHT 50
DISCOUNT 40
Detail rows for 2nd KIA row in Master:
PRICE 20
WEIGHT 15
DISCOUNT 30
What I would like to manage is this result for master-detail:
-to group master rows + group/sum detail rows for them:
1 MASTER row as result: KIA
DETAIL: PRICE 30
WEIGHT 65
DISCOUNT 70
Next would be MASTER for AUDI and its DETAIL with PRICE WEIGHT and DISCOUNT etc.
How to do this in fast report .net, please?
imagine following data structure for Master and Detail:
MASTER: some column has some rows with same value(order number for example) like following
KIA
KIA
AUDI
AUDI
BMW
DETAIL: each detail has same structure
Detail rows for 1st KIA row in Master:
PRICE 10
WEIGHT 50
DISCOUNT 40
Detail rows for 2nd KIA row in Master:
PRICE 20
WEIGHT 15
DISCOUNT 30
What I would like to manage is this result for master-detail:
-to group master rows + group/sum detail rows for them:
1 MASTER row as result: KIA
DETAIL: PRICE 30
WEIGHT 65
DISCOUNT 70
Next would be MASTER for AUDI and its DETAIL with PRICE WEIGHT and DISCOUNT etc.
How to do this in fast report .net, please?