0

Returning next record

Jet Reports Historic Posts

January 01, 2013 15:03

None

Follow

Hi Hughes

Sorry, my bad - I did not run the report :oops:
Just evaluated the formula.

It is working now.

Thanks for your help.

Br.
Mdp12

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts January 01, 2013 15:03

  Hi
  
  I have a simple question.
  I have an invoice no. 200 for a certain customer XXX.
  
  How do I return the next invoice no. for the same customer ?
  
  I have tried something like:
  =NL(2;"sales invoice header";"no.";"+no.";"200..";"bill-to customer no.";"XXX")
  But it is not working.
  
  Any help will be appreciated.
  
  Br.
  mdp12

• 0
  
  Jet Reports Historic Posts January 02, 2013 15:51

  Hi mdp12,
  
  I'm assuming your formula there should work. A formula like that won't be evaluated properly until you actually run the report by going to Jet -> Report or Jet -> Refresh. You should know that values in design mode are not guaranteed to be correct because they are optimized for speed of creating reports. Did you actually run the report and did it not give you the result you expect?
  
  Regards,
  Hughes