Hi, I'm new to JetReports - given the licence and told to construct meaningful reports. No training and only the F1 Help documentation.
I am trying to return items with a negative inventory holding. At present I have a dump of all item numbers and am using JetReports to bring out the inventory. A quick formula hides the zero and posative inventory lines.
Is there a better/easier way to do this please? Obviously every time a new item is added to the database I need to update the dump on items I use in Excel.
Thanks,
Scott
Date
Votes
2 comments
-
Jet Reports Historic Posts Hey,
What you ask is very basic stuff, but no worry, you're new :).
First off, instead of using a "dump", you can use the NL function on the item table ("rows") and so return all item numbers.
Then you can use them to get a sum from the item ledger entry (or whatever table you get your stock from).
You still have to conditionally hide the cells (because you ask for ALL items), but you would have a better report (items are fetched auto).
When that works out, check some documentation on the "filter" and "link" property of the NL function, so that you only list items that have negative stock (you filter them in advance, you have less data to fetch -> faster report).
If you have any specific questions, you can contact me trough pm/mail.
Regards,
Jan -
Jet Reports Historic Posts Don't forget you can always use the knowledge base articles on the support site too!
Please sign in to leave a comment.