Hello,
In a Sales report we use the Sales Comment Line to report us about the status of a quote. Every time a comment line is added this shows as a separate line in the report, resulting in a very large report. What filter can be used to show nothing but the latest comment line?
Kind regards,
Michel
Date
Votes
5 comments
-
Jet Reports Historic Posts Official comment Another Idea.
Don't know if it works with Jet 4.0.7, though.
You could sort by Date (or if you want the last entry, by Linenumber) and then
set the limit of the returned Lines to 1.
It could look like this (just for instance):
=NL("Rows";"Sales Comment Line";;"+Date";"*";"Limit=";"1")
I don't know which entry Jet would take if more than one Comment is made a day.
Guess no seconds are available.
It's maybe better to sort by Linenumber to get the last entry (or the first, depending on how
you use the comments)
Edit: It should work with 4.0.7, this method is already contained in the manual. -
Jet Reports Historic Posts Hello mleerlooijer
if I understand that correctly you just need to change the "What - Argument" of your formula
from "Rows" to "Last" to get the last entry, that fits to your Filter (but i guess this only works if you
add a new entry below the old entry, else the last entry in the table won't be the one who was last created) -
Jet Reports Historic Posts Hello Goblin,
Tried it, but… failed. While surfing the Web we found out that sadly, due to our Jet 4.0.7 version, we can't work with the "Last" formula.
Kind regards,
Michel -
Jet Reports Historic Posts Hoi Michel,
It's been a while since I worked with version 4…. How about "-1" instead of "Last"? Does that work?
Did you know that you may download and install Jet Reports v7 for free if you have a current support / upgrade license with Jet Reports? Check the "upgrade to" field in your Jet Reports license file. Or contact your Jet Reports dealer to help you about it - or if you wish to renew the license. I assure you version 7 is worth it!
groetjes,
Hans -
Jet Reports Historic Posts Hallo Hans,
Thanks to your comment we did update to a up to date version of JetReports. It works great and my problem is solved, thanks!
Groeten,
Michel
Please sign in to leave a comment.