Grouping values in report based on the options present.

Business Central/NAV Technical Forum
1

Hi All,

Couldnt actually find a better title(So please bare with me on this one)

What i mean by this is,

Input…

Phase Type value
Diagnostic 14
Diagnostic 12
Analysis 23
Analysis 10
Design 11
Design 11

OUTPUT

Phase Type value
Diagnostic 26
Analysis 33
Design 22

Where ‘Phase Type’ is a setup table.
I tried summing it using setrange and filters…but its not coming correctly… thanks…

2

Did you try by GroupTotalFields? and show the value in footer section?

if it is a flow field mention CalcFields fro value…

3

hi,

tried all those…Not working…

But these values should be shown in the body part not in the footer…Footet i show the total of all the phase type…

4

Hi all…

i figured out the solution…did it throught coding itself…

5

sorry…not in footer section…group footer section… [Y]

6

Hi Shona,

Using the groupfooter is the normal way to do this - you can use the report create wizard to create a sample report and hide/delete the body section.

7

You can use variables and write code for them if you are not getting desired result report generation wizard.

8

why should we write code if something can be achieved by existing properties?

9

Hi Shona,

Did you ever find a solution to your problem? If you did, would you mind sharing it with us and if any of the posted answers helped you on the way, then please verify them.

Thank you.