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

(0) Share

Report

Posted on by Community Member

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:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Inge M. Bruvik 1,105 Moderator 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.

Was this reply helpful? Yes No
Community Member 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

Was this reply helpful? Yes No