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