Hi Everyone.
I am new at Jet Reports… so hope you all can help.
I am using the Jet Reports example report "Monthly Income Statement".
I would like to point this report to display the Additional Reporting Currency Balance instead of the G/L balance.
I used the flowfield function as follows
FlowField([62 Additional-Currency Balance],[No.],[6195])
When my Report runs the report returns
FlowField([62 Additional-Currency Balance],[No.],[6195])
Rather than returning a value
Does Anyone have an Idea Where I am going wrong …
Date
Votes
2 comments
-
Jet Reports Historic Posts The Jet Essentials Forumla Used is
=IF(Options!C$4<>0,-NL("Sum","G/L Account","Additional-Currency Net Change","No.",$B11,"Date Filter",Options!C$4,"Global Dimension 1 Filter",$C11,"Global Dimension 2 Filter",$D11,"company=","Midema s.a.r.l. - CCLD"),0)
I am trying to figure out how to do this in Jet Express -
Jet Reports Historic Posts Hi Anton,
You could use the Table Builder feature to pull in Additional Currency Balances from the G/L Account Table, but you will be limited to Pivot Table formatting to see your results.
You won't be able to create a 'freeform' report like the Monthly Income Statement off Additional Currencies using Jet Express.
For that you would need to use functionality which is only available in Jet Essentials.
The NL(Flowfield) function is only used to support the Table Builder functionality. You''re not going to be able to use this a query to return any data.
Steve
Please sign in to leave a comment.