Grouped Dimension Values

Business Central/NAV Developers Forum
1

Hi all,

REPORT:

Should display my grouped dimension values (in my case, activities). that is, group 1: activities from 100…200, group 2: activities from 300…400 etc.The report gets values from g/l budget entry table and g/l entry table.

I have managed to get values from the above specified data items, when all activities are listed in order without groupings. however, i am not clear on how to go about displaying the groupings.

Following are the dataitems i have used:

=============================

Dimension Value

G/L Budget Entry

Ledger Entry Dimension

G/L Entry

Integer
= =====================

Example result

Description

REVISED BUDGET

ACTUAL EXPENSES

BALANCE

1000002
Participate in the TICAD & AU-EU Dialogue

0.00


-4.47


4.47
1000003
Resource mobilisation visits

0.00


-30.40


30.40
1000004
Publication in international press

0.00


-30.40


30.40
1000005
Entertainment

0.00


-30.40


30.40
1499997
Staff Costs

0.00


125.00


-125.00
1500001
Organise SMT meetings

0.00


125.00


-125.00
1500002
Develop Technical capacity of selected MAs

0.00


125.00


-125.00
1999997
Staff Costs

0.00


125.00


-125.00
2000002
Global Youth Day Commemoration

0.00


125.00


-125.00
2000003
World Aids Day Commemoration

0.00


125.00


-125.00
2000004
Develop YAM sub regional advocacy campaign

0.00


-59.61


59.61
2000005
Mainstream YPLWA Guide

0.00


-59.61


59.61
2000006
Mainstream Peer Educatn Guide with CO

0.00


-59.61


59.61
2000007
Young people participn in the RC and youth forum

0.00


-59.61


59.61
2000008
Train Lusophone YAM representatives with WHR

0.00


-59.61


59.61
2000009
ARO Internship Programme

0.00


-1,550.00


1,550.00

kindly assist.

thanks.

2

Hi nthesh,

You can use grouping on the dimension value (in the GroupTotalFields property ) in your report and then decide when to print the group sub-totals with
CurrReport.SHOWOUTPUT command to determine what total to print. I’m a bit concerned about you report structure as it looks to me that if a G/L account does not have a dimension or budget it will not print.

I suspect that you have added all these sections to print value but using a variable of type record and finding/calculating would be a lot easier.

Hope this helps.

3

Thanks. I’m still not there yet! On the report trigger(OnPreReport), i have defined the groupings filters. When and how to set the filters is an issue.

4

Can you give me an example and I can try to help?