Reports: Get field value from previous row and add it to current row

(0) Share

Report

Posted on by Charbel Hleyhel

Hello,
I am generating a report in business central using the vendor general ledger entry table.

I am trying to sum the balance on each line based on the amount of the line plus the line balance previously calculated. I cannot set a previous amount since I have multiple groups with multiple currencies and would like to retrieve the amount of the previous line based on the group.

I have attached an image with the values I am getting without calculations (Black) with the values I would want to its left (red).

I am still new to business central development.

If i have no way of doing it I think I will have to sort by currency and just do the calculations but i would love to hear your suggestions.

All responses (4)

Answers (2)

Suggested answer

Saurav.Dhyani 17,965 Super User 2024 Season 2 on at

Like (0)

Report

RE: Reports: Get field value from previous row and add it to current row

Here is an example how to achieve running totals in a RDLC Report -
Charbel Hleyhel 60 on at

Like (0)

Report

RE: Reports: Get field value from previous row and add it to current row

That is an interesting way of doing it and will test it the next time I would need to implement such feature!

Thank you!
Verified answer

Greg Enns 1,102 on at

Like (2)

Report

RE: Reports: Get field value from previous row and add it to current row

Thanks for sharing your answer. As an alternate solution, you should also be able to do this in AL using a variable that you include in the dataset.

See the NetWeight example here: learn.microsoft.com/.../devenv-report-ext-object
Verified answer

Charbel Hleyhel 60 on at

Like (1)

Report

RE: Reports: Get field value from previous row and add it to current row

I was able to fix it using the runningValue function in report builder with the scope as the group.