• How to write SQL statement for percentage in subtotal and total rows?

    How to write SQL statement for percentage in subtotal and total rows?

    Getting % on detail rows is no problem, but when trying to get a % on the subtotal or total rows eludes me.

    Any help on this would be greatly appreciated. Thanks so much!

  • No Backup Warning Message

    If your workstations are receiving the "No Backup Warning" message when they log into Sage 100 Contractor 2016 (version 20.4.51.0 or less) it may be caused by...

    • a missing component of Database Administration for Sage 100 Contractor SQL (DA…
  • Use of SQL in Sage 100 Contractor Report Writer

    Can anyone tell me how to create a calculated field that has a SQL statement bringing in data from an unrelated table?  I've looked at fields on other reports that I think are doing approximately the same thing but when I modify the SQL statement I keep…