| Use SP_PARAMETERS reportname to list all the parameters available for a given SP_REPORT. The VALUES column lists available values that can be used with the parameter.
In: Quick Report on an Account I used:
sp_report CustomTxnDetail show TxnType, Date, RefNumber, Name, Memo,
Account, ClearedStatus, SplitAccount, Debit, Credit
parameters DateMacro = 'ThisYearToDate', AccountFilterFullNames = 'Suspense Income',
SummarizeRowsBy = 'Account',
OpenBalanceAsOf = 'ReportEndDate'
To total the account credits and debits.
To collapse a report use where {fn LOCATE(':', "RowData", 2)} = 0 or Text <> '' for example:-
sp_report ProfitAndLossBudgetVsActual show Text, Label, Amount, Budget,
Percent parameters FiscalYear = 2006, BudgetCriterion = 'Accounts',
SummarizeBudgetColumnsBy = 'Date', SummarizeBudgetRowsBy = 'Account'
where {fn LOCATE(':', "RowData", 2)} = 0 or Text <> '' |
