Good day all,
Does anyone know how i can create a report where i only bring back Customers where their Balance has exceeded their credit limit.
It is easy enough to bring back all customers and then create a conditional hide based on a formula that checks the difference between the 2 fields and hide the lines where they are within their limit or even bring back the table and create a pivot table which has a filter preset to show only the exceeded ones.
I would prefer however to not bring back unnecessary records.
Many thanks
Tom
Date
Votes
3 comments
-
Jet Reports Historic Posts hello ,
please have a look at this http://kb.jetreports.com/article/AA-00507/25/.
i think that would be helpful ?!
regards
jetsetter -
Jet Reports Historic Posts Hi Jetsetter,
Absolutely brilliant - I don't fully understand the syntax of the formulas but I was able to achieve what I needed.
Thank you very much
Tom -
Jet Reports Historic Posts great! :D
good to hear!
regards
jetsetter
Please sign in to leave a comment.