[QODBC-Desktop] How to run a Time by Job Summary Report in QODBC
Posted by brad waddell on 12 March 2009 05:21 PM
Typical Time by Job Summary Report in QuickBooks
Report Displayed in QODBC
Stored Procedure Command
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"
Display in QODBC
Note: When using QODBC, the duration is available as minutes and hours, but not in a HH: MM format as seen in QuickBooks.