sp_report ProfitAndLossDetail show TxnType_Title, Date_Title, RefNumber_Title, Name_Title, Memo_Title, ClearedStatus_Title, SplitAccount_Title, Debit_Title, Credit_Title, RunningBalance_Title, Text, Blank, TxnType, Date, RefNumber, Name, Memo, ClearedStatus, SplitAccount, Debit, Credit, RunningBalance,AccountFullName,AccountType,RowType,Case When AccountFullName='Professional Services Fees' then AccountFullName Else 'Other' End as AccName parameters DateFrom={d'2008-01-01'} , DateTo={d'2008-11-30' },AccountFilterType='IncomeAndOtherIncome'
But this Statement is not Excecute |