I need to get subcolumn totals for year-to-date on the profit and loss by job. I have run the following command in Access:

sp_report ProfitAndLossByJob show Amount_Title, Text, Label, Amount parameters DateMacro = 'LastMonth', SummarizeColumnsBy = 'Customer', IncludeSubColumns = 'Yes' 

But the IncludeSubColumns does not return the year-to-date figure that I need. I only get the last month, the month before that, and then last month a year ago. How can I also get year-to-date (through the end of the last month, that is). I know that I could use the DateMacro to pull out only the YTD figures, but I also need the monthly totals. ?? I'm new to all of this, so please pardon my ignorance.

The use of SubColumns is currently not supported. You can see the report that QODBC is trying to build in QuickBooks by adding the DisplayReport= 'Yes' tag like this:-

sp_report ProfitAndLossByJob show Amount_Title, Text, Label, Amount
parameters DateMacro = 'LastMonth', SummarizeColumnsBy = 'Customer',
IncludeSubColumns = 'Yes', DisplayReport= 'Yes'

This will give you a better idea what the report is trying to represent. You will note that the % of Row and % of Column figures are incorrect in QODBC and the YTD is unchecked, so the column is missing.

Shoot! Thanks anyway.

Sally