Forum : How do I run a Balance Sheet Standard Report?Search Forum

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

 New Topic 
 
 Post Reply 
 How do I run a Balance Sheet Standard Report? 
 Author   Message 
  Tom Aczel 
  dd4bf_dawworld.jpg
 Group: Administrator 
 Posts: 6281 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-03-30 12:15:00

A typical Balance Sheet Standard Report looks like this:

With QODBC the same report can be generated using stored procedure reports like this:

sp_report BalanceSheetStandard show Text, Label, Amount_1 as Amount, Amount_1_Title as "As of"
parameters DateMacro = 'ThisYearToDate', SummarizeColumnsBy = 'TotalOnly'

All the predefined DateMacro options available to you are:
|All|Today|ThisWeek|ThisWeekToDate|ThisMonth|ThisMonthToDate|ThisQuarter|ThisQuarterToDate
|ThisYear|ThisYearToDate|Yesterday|LastWeek|LastWeekToDate|LastMonth|LastMonthToDate|LastQuarter
|LastQuarterToDate|LastYear|LastYearToDate|NextWeek|NextFourWeeks|NextMonth|NextQuarter|NextYear|

 

  Top 
 New Topic 
 
 Post Reply 

Jump to