0

Only show the latest Line No.

Jet Reports Historic Posts

March 04, 2009 10:10

None

Follow

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

• Facebook
• Twitter
• LinkedIn

5 comments

• 
  Jet Reports Historic Posts March 04, 2009 14:25 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.

• 0
  
  Jet Reports Historic Posts March 04, 2009 10:49

  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)

• 0
  
  Jet Reports Historic Posts March 04, 2009 12:40

  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

• 0
  
  Jet Reports Historic Posts March 04, 2009 14:18

  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

• 0
  
  Jet Reports Historic Posts April 21, 2009 08:18

  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