Forum : How do I run a Time by Job Summary Report?Search Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC Reporting Forum

 New Topic 
 
 Post Reply 
 How do I run a Time by Job Summary Report? 
 Author   Message 
  Tom Aczel 
  dd4bf_dawworld.jpg
 Group: Administrator 
 Posts: 6281 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-02-09 11:12:39

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.

 

  Top 
 New Topic 
 
 Post Reply 

Jump to