How to Get the custome balance total based ont he customer no In RDLC REPORT

(0) Share

Report

Posted on by Community Member Microsoft Employee

I have a custom report copy of the standard rdlc report customer balance to date -121

When I run the report with filter with customer no it shows the total correctly , When I run the report without any filter for every customers how can i get the customer total based on their Customer Number

Categories:

Business Central

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (1)

Report

RE: How to Get the custome balance total based ont he customer no In RDLC REPORT

Thank you it helped
Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

RE: How to Get the custome balance total based ont he customer no In RDLC REPORT

You have to look at the date filters you set in your report.

Find this line in the code

SetRange("Date Filter", 0D, MaxDate);

And change it to

SetRange("Date Filter", 0D, today());

That should solve your problem. Then the report will always calc the balance to the current date.

You can also create a new simpler report.