Hi,
I have to add columns in my report but the problem is that these columns must display data from the same field with different filters.
I would like to make my report looks like this :
Column1 : Clien ; Column2: Remaing amount where d1<due date<d1-30 ; Column3 : Remaing amount where d1<due date<d1-60 ;
Is there any solution with jet Express, I tried everything reached my purpose.
Can anyone help me please. Thank you
Date
Votes
3 comments
-
Jet Reports Historic Posts Hello mehdi.souihli,
You could do this with Jet Express using certain FlowFields (e.g. Net Change) if they have a date filter available to them, but due date is not one of them.
Beyond those FlowFields you would need to utilize Jet Essentials to accomplish this.
I have attached a screenshot showing this functionality.
Best regards,
MWilson
-
Jet Reports Historic Posts Hi Mwlison ,
Thank you for your help i found an other solution with linksum function.I used customer table as principal table and added linksum fields from cust ledg entry for every range. it worked perfectly.
Your reply will help me to make more easily other reports but do you know if there is a way to make other filters available for a flowfield when needed? -
Jet Reports Historic Posts Hello mehdi.souihli,
These are defined within the field details in the NAV Classic Client (2009R2 or earlier) or NAV Development Environment (2013/2015).
See attached for reference.
Best regards,
MWilson
Please sign in to leave a comment.