mistux Site Admin
Joined: 25 Jun 2004 Posts: 1042 Location: South Bend, Indiana USA
|
Posted: Mon Dec 29, 2008 1:00 pm Post subject: ODBC Code for Profit and Loss report showing each month |
|
|
Here is the ODBC Pass-Through query for a Profit and Loss report showing each month:
Code: | sp_report ProfitAndLossStandard
show
AccountNumber, Label, Amount
parameters
DateFrom= {d'2008-01-01'}, DateTo= {d'2008-12-31'}, SummarizeColumnsBy = 'Month' |
You can set the connection information by entering the info on the properties of the query. |
|