SQL EXAMPLES FOR: Job Estimates Vs Actuals Detail

SQL STATEMENT EXAMPLES

sp_report JobEstimatesVsActualsDetail show AmountEstCost_Title, AmountActualCost_Title, AmountDifferenceCost_Title, AmountEstRevenue_Title, AmountActualRevenue_Title, AmountDifferenceRevenue_Title, Text, Label, AmountEstCost, AmountActualCost, AmountDifferenceCost, AmountEstRevenue, AmountActualRevenue, AmountDifferenceRevenue parameters DateMacro = 'All', EntityFilterFullNameWithChildren = 'Cook, Brian', SummarizeColumnsBy = 'TotalOnly'