Group/ Total in Report

Dynamics 365 Business Central/NAV User Forum
1

Hi

I have one maybe too beginner question related with grouping in CC reports.

For every job I should calculate the Quantity in hours of Capacity Ledger Entries

but ,every Capacity Ledger Entry has an “Assembly No.” and should to be calculated total of field “Quantity (h)” for every Assembly No.

So how can I group by Assembly No in CC and after that to calculate the hours for each?

I added new key in Capacity Ledger Entry Table, and after that I filed in Capacity Ledger Entry-DataItem, DataItemTableView property with SORTING(Assembly No.).

I tried with:

In Group Total Fields to add: Quantiti(H) and using groupfooter for showing but in this case footer is not printed

If I filled Group total fields with Assembly No. then total is printed but that is sum of ALL ledger entries for that Job, NOT grouped by Assembly No.

How can I solve this, this is my first time to create report from scratch and it loокs confusing for me.

Thanks in Advance

2

And one more thing : How can be improved the performance of the report in order to work faster. Because I use Job Table and Ledger Entry Tables and they contain too many records so printing of the report takes to much time. Is there some way to achieve that?

Thanks

3

Is this a classic report or RDLC report ???

4

Classic

5

Hi Alen,

Am also facing the same issue which you described above…

Can you Pls help me out for the same?