SQL EXAMPLES FOR: Job Estimates Vs Actuals Summary

SQL STATEMENT EXAMPLES
sp_report JobEstimatesVsActualsSummary show AmountEstCost_Title, AmountActualCost_Title, AmountDifferenceCost_Title, AmountEstRevenue_Title, AmountActualRevenue_Title, AmountDifferenceRevenue_Title, Text, Label, AmountEstCost, AmountActualCost, AmountDifferenceCost, AmountEstRevenue, AmountActualRevenue, AmountDifferenceRevenue parameters DateMacro = 'All', SummarizeColumnsBy = 'TotalOnly'