0

Jet Express Function Wizard HELP [RESOLVED]

Jet Reports Historic Posts

September 02, 2011 11:39

None

Follow

Hi Again,

Is there any online videos for the Function Wizard? The other online videos where very helpful. It would be nice to see a video for this as well

Thanks

PaddyPower

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts September 02, 2011 15:54

  Hi paddypower,
  
  Thanks for the suggestion! I will add it to the list of requests.

• 0
  
  Jet Reports Historic Posts September 26, 2011 15:45

  Is there any information available regarding Function Wizard?
  I'm not able to figure out how to get values from this function, or is there a limitation in the Express-version regarding this?
  
  =NL("FlowField";"Customer";"Balance Due (LCY)";"No.";"2544")
  
  Gives the following result:
  FlowField([Balance Due (LCY)],[No.],[2544])
  
  I've expected to get the actual value for the Balance of the customer.
  Am I stupid or?

• 0
  
  Jet Reports Historic Posts September 26, 2011 21:09

  The NL("Flowfield") function returns a string used to retrieve a FlowField from the primary table in an NL(Table) function (it does not retrieve the flowfield data itself).
  
  As an example, I used the Table Builder to create a table showing my customer numbers, names, and balances as of a particular date range
  
  1 Auto+Hide+Values 3 Hide Tables and Fields Filters 4 Hide 18 Customer 5 Hide Balance 6 Hide 55 Date Filter 1/1/2000..1/31/2000 7 8 Hide Headers: No. Name Balance 9 Hide Fields: 1 No. 2 Name FlowField([58 Balance],[55 Date Filter],[1/1/2000..1/31/2000]) <– this is the =NL("FlowField") function 10 Table <– this is the =NL("Table","18 Customer",$E$9:$G$9,"Headers=",$E$8:$G$8,"TableName=","18 Customer")
  -HP