• Using SQL queries in a calculated field (report writer)

    Hello - I am struggling with the report writer and need some clarification (a long shot, since there is almost 0 documentation on the subject). I am proficient in T-SQL, so am confident in my ability to write queries, but can't get something very simple…
  • Project file

    Sage Estimating version 20.2 Does anyone know if it is posssible to e-mail a project file to another Sage user without them have a copy of the database? And if so what files do we send and will they be able to open the file with there Sage Estimating…
  • upgraded from 18.12 to 20.1 all report layouts show under layouts but they are all wrong

    We upgraded Estimating last night and now any report layout you choose the previous settings are gone
  • Sage 100 Contractor Sql in Report Writer

    FormerMember
    FormerMember
    Does anyone know where I could find information for the syntax that Sage 100 Contractor report writer requires with respect to SQL. I am trying to write a report for Committed Costs that is different from the report included with Sage, so I need to write…
  • 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!