Adding up numeric asset fields
Is it possible to add up numeric asset fields
in the k1000. For instance the cost of items
or any other asset field that has numbers.
Can I generate a report that adds up all the
fields and gives me a total ???
Thanks All.
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
StockTrader
8 years ago
Hello,
What you can do to ease the creation of the SQL report is to create a sort of blueprint with the wizard and then modify the SQL of the report.
If you like to play a bit more interactively with the SQL and KACE you can enable in the Settings -> Security Settings the database access and use something like TOAD for MySQL or MySQL Workbench (free products) to better model your query.
This video explains how to connect to the K1000 database:
kind regards,
Marco - StockTrader
Comments:
-
Thanks for the quick reply Stocktrader...
Cheers mate. - akmagnum 8 years ago-
You're welcome :-) - StockTrader 8 years ago