How to create report which do sum of fields with group by

Business Central/NAV Developers Forum
1

Dear All,

I am creating a stock report with two data items : 1st data item is Item Table & 2nd data item is Item Ledger Entry Table, then i created DataitemLink on item between both tables.

Now i want to show current stock in report so i added required fields on body sections of Item Ledger Entry, but report showing multiple entries vide single article. I already added itemno of ILE in Value of GroupTotalFields to show single article. But it is showing all entries from ILE vide single article.

Please help me.

Rgrds

Neel

2

Use all fields on Footer Section