AX 2012 Report

Finance and Operations/AX Technical Forum
1

Hi All,

I need to create a report in Ax 2012 with Group and Subgroups, below is the format for the same. In this case EAC is the group which includes its corresponding subgroup name EAC 1 and 2 with price values.

· Name Price

EAC

EAC 1

EAC 2

Debate

Debate 1

2.22
4.32

5.63

2

Hi Pankaj,

so, you want to get this design in your report… Please elaborate it clearly…

3

Hi Pankaj,

Suppose you are having two fields ‘Group’ and ‘SubGroup’ in your table. Then in this case your records are:

Group SubGroup Price

EAC EAC1 2.22

EAC EAC2 4.32

Update Debate1 5.63

Then you have use Group field as parent group and SubGroup as the child group.

4

This can be done in Visual Studio and you have to apply row grouping and add set the desired fields in the two groups subsequently.

5

Hi Pankaj,

Take 3 programmable sections…

Using first one print the labels name, Price…

using the second one print the Groups- names…

Using the third just print the details, i mean to say sub groups and prices…

6

Thanks for the reply guys,

I am bit new to ax so getting issues with the development, in my report I have two data sources A and B.

under heading Subgroup data is coming from description field of Table B, and under ‘Group’ data is coming from display method which picks up the names according to the ‘subgroups’.

Output from my code:

Groups Subgroups

C c1

c c2

b b1

b b2

c c3

Desired Output:

c

c1

c2

c3

b

b1

b2

I need an example, please help. Thanks… :slight_smile:

7

Hi pankaj,

can u say what are the fields that are there in two tables…