Hi!
I want to filter a Report based on "Posting Date" = "Due Date"-3
In the Detail rows, I used a "Hide" formula and Hide+? on cells in the =NL("Rows"…) function and it's correctly hiding the detail rows.
How do I filter so the Grouping rows of my report only shows header rows where the "Posting Date" = "Due Date" - 3 ? I can't get "Hide" to work, and thought there might be an NL function that I'm missing.
TIA!
-John
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hughes,
Bingo! :D
Yes, both fields are in the same table, and THAT'S the formula I was missing! I simply put the "Posting Date","=NF(,""Due Date"")-3" into another Filter/FilterField position in both the header and row NL and it worked.
Thanks loads! I love this forum…. 8-) -
Jet Reports Historic Posts Hi John,
It is possible in NAV to do a filter something like this:=NL("Rows","Table",,"Posting Date","=NF(,""Due Date"")-3")
This is assuming that both Posting Date and Due Date are in "Table". In your case I'm assuming when you are trying to hide the grouping rows that you're dealing with a different table right? You could probably do this using Link= but it depends on what the tables are and how they're related.
Regards,
Hughes
Please sign in to leave a comment.