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|
|