Report issue

Finance and Operations/AX Technical Forum
1

Hi Experts,

I have one issue …i.e

I designed one dynamic report with ’ A 'datasource ,by relating that i want to display some in and out information.The report design is like

In Info :

customer day1 day2 day3 day4 …

a 2 1 0 x

b x x 1 x

Out Info :

customer day1 day2 day3 day4 …

a 1 1 2 x

b 0 x 1 x

The problem is i am geting the exact data but when i am trying to display the same i am getting problem it is displaying like(as i am using the same datasource)

customer day1 day2 day3 day4 …

a 2 1 0 x

a 1 1 2 x

b x x 1 x

b 0 x 1 x

Please help me anybody it very urgent…thanks in advance

2

Hi,

How do u differentiate in and out information? if there is a field for that you can order the data with that field.

and in the executesection, if the field value changes from ‘in’ to ‘out’ display the header if you want.

  • Arun
3

If there is a field to differentiate apply a group by on that…

4

Hi ,

Thanks for reply…there is no field to do group by…

I am using ProjInvoiveTable in my datasource

the requirment is, i hav one ‘GuestTable’ which hav ProjId ,qty, In dateTime ,OutDateTime …,I need to show the In and Out guests ‘qty’ for particular customer.

The customer is related as GuestTable’s ‘projId’ → ProjTable’s ‘ProjContract’ -->ProjInvoiveTable’s ‘CustAccount’

i want to display the info customer wise and day wise