A typical Time by Job Summary Report in QuickBooks looks like this:
With QODBC the same report can be generated using stored procedure reports like this:
sp_report TimeByJobSummary show Label, Duration_1 as "Dur Minutes", DurationHours_1 as "Dur Hours" parameters DateMacro = 'All', SummarizeColumnsBy = 'TotalOnly' where Label like 'Total%'
Note: When using QODBC, the duration is available as minutes and hours, but not in a HH:MM format as seen in QuickBooks.
|