Knowledgebase: Sp_commands & Reports
[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"
     parameters DateMacro = 'All', SummarizeColumnsBy = 'TotalOnly' where Label like 'Total%'

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.

(196 vote(s))
Helpful
Not helpful

Comments (1)
Angie
20 September 2012 12:33 PM
You got to push it-this essenital info that is!
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).