how to group fields in the report in NAV 2009 R2

Dynamics 365 Business Central/NAV Developers Forum
1

hi,

I am jst working in report,how can i group the fields in the report. i mean if i work on item ledger entry list report and i want item no comes 1st and related data comes under that item no. and each no print only one time. can anyone help me?

2

This “grouping” is done by the item number (group by)
The item itself needs to go into the group header for that group.

3

Thanks Sir,

But sir i have to group three field.

Ex - i have 5 fields

Item no Entry type posting date location code Amount

1100

sale

01/12/2015 BLUE -3500

purchase

02/12/2015 green 250

1200

sale

01/12/2015 BLUE 250

It should be look like this so what to do

now my report look like below

Item No. Entry Type Posting date Location Cod Cost Amount (A
1001
Sale 01/27/11 BLUE -3,505.94
Sale 01/27/11 YELLOW -3,505.94
-7,011.88
1100
Positive Adj 06/01/10 934.20
Consumptio 09/09/11 -648.36
Consumptio 09/10/11 -3,501.12
Consumptio 09/11/11 2,074.74
Sale 01/27/11 BLUE 2500

4

Thanks Sir,

But sir i have to group three field.

Ex - i have 5 fields

Item no Entry type posting date location code Amount

1100

sale

01/12/2015 BLUE -3500

purchase

02/12/2015 green 250

1200

sale

01/12/2015 BLUE 250

It should be look like this so what to do

now my report look like below

Item No. Entry Type Posting date Location Cod Cost Amount (A
1001
Sale 01/27/11 BLUE -3,505.94
Sale 01/27/11 YELLOW -3,505.94
-7,011.88
1100
Positive Adj 06/01/10 934.20
Consumptio 09/09/11 -648.36
Consumptio 09/10/11 -3,501.12
Consumptio 09/11/11 2,074.74
Sale 01/27/11 BLUE 2500

5

You can create nested groups.

You will find an example in Report 206 Sales Invoice, which already uses exactly these nested groups you are asking for.

6

So your first group is grouping by “Item No.” and the second group is grouping by “Item No.” and “Entry Type”.
Third group could group by “Item No.”, “Entry Type” and “Source No.” if you want.

7

for the nested group i have to write code or what? because in report 206 lots of table used, but i am using only one field,and for grouping we required group total fields and Item table view properties for key selection because which field i am going to make grouped that must be selected in the item table view properties,but how can i select more field in that properties.If it will done by code then pls guide me

8

You need to create key on item ledger entry table and use it in the report

9

Thanks sir,

But i have to group several fields not only one field,so how can i do

10

you need to create a key with all fields…