255
Hey,
we have a issue with statement report on NAV 2017. When we print customer statement, the total customer balance on the list appears on every page. Is there a way to make it print on last page?.
i tried several possible solutions, and nothing worked.
*This post is locked for comments
Hi,
This is because this field / row is inside a group.
Export the report as backup.
Delete the group of this row and try to print, it should be printed after all customer records.
You can also use the row visibility property.
In NAV2018 it is managed by a variable (GroupNo), and the hidden expression is:
=iif(Fields!GroupNo.Value = Last(Fields!GroupNo.Value, "DataSet_Result"), False, True)
I do not remember how is it handled in 2017 but you can try something like (if you want to keep the row grouped)
=iif(Fields!CustomerNo.Value = Last(Fields!CustomerNo.Value, "DataSet_Result"), False, True)
I hope it helps
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (