I think you need use data method. This's my blog page about data method's. Header talks about AX 2012, but ignore the header. Important point; it's about SSRS:

http://metinemreenglish.blogspot.com.tr/2017/11/ax-2012-ssrs-report-carry-forward-and.html


>The table contains these columns:
>sytemid
>eventtime
>eventcode
>eventamount
>
>I want a report that shows, for each systemid, the sum of the eventamount column for an event until another event occurs, the events are in eventime sequence.
>Event A could have one row, then an event B at a later time, and then another A at yet a later time. I that case I want three totals.
>
>
>
>HELP!