We upgraded to 4.02 SQL earlier this year and I have finaly had time to start using Visual Studio to create reports. It has been amazing compared to trying to do it via C/Side previously. We need to create some reports that will need to have date from items that are flow fields in NAV. The big one for me is Inventory.
Do you need to calculate the inventory everytime from the entire Item Ledger Table based on item number, location, etc? This seems like it will really slow down the report if done on the live database.
What is the preffered method to get a quantity on hand for an item (tables needed, expresion syntax, etc) for efficiently generating the quantity on hand?
It might be nice to setup a Forum specifically for SQL / SRS / NAV?