Hello.  Can give me some direction in writing a query to produce a report that shows the bottom line Profit & Loss number only for each (or a given list of) class?  I'm interesting in a simply view that includes basically only the class name and their bottom line number; one row for each class and excluding subclasses...  Thank you in advance!

If you mean the Net Income (botton line) for each Class.

Then this query will give you the results:

sp_report ProfitAndLossByClass show Text, Label, Amount
parameters DateMacro = 'ThisYearToDate',
SummarizeColumnsBy = 'Class' where Label='Net Income'

Sorry, you are going a little beyond the scope of this forum here. You cannot run subqueries within a stored procedure, however, you can rename the columns with a static list (or programmed variables) like this:

sp_report ProfitAndLossByClass show Text, Label,
Amount_1 as "New Construction",
Amount_2 as "Total New Construction",
Amount_3 as "Remodel"
parameters DateMacro = 'ThisYearToDate',
SummarizeColumnsBy = 'Class' where Label='Net Income'

and to do the format layout you wish, you can call the report a number of times for each class like this:

sp_report ProfitAndLossByClass show Text as "New Construction", Label, Amount
parameters DateMacro = 'ThisYearToDate',
SummarizeColumnsBy = 'Class', ClassFilterFullNameWithChildren='New Construction'
where Label='Net Income'

sp_report ProfitAndLossByClass show Text as "Remodel", Label, Amount
parameters DateMacro = 'ThisYearToDate',
SummarizeColumnsBy = 'Class', ClassFilterFullNameWithChildren='Remodel'
where Label='Net Income'

I would like to get the data by Class for multiple months.  Something like this:

Account, Class, Amount_1 as "Month 1", Amount_2 as "Month 2", Amount_3 as "Month 3", etc

Basically, I want the Class data in rows and not columns.  Is it possible?

You can do it, but you would need to run the report for each class like this:

sp_report ProfitAndLossbyClass show Text, Label, Amount_1_Title as Month_1, Amount_1,
Amount_2_Title as Month_2, Amount_2, Amount_3_Title as Month_3, Amount_3,
Amount_4_Title as Month_4, Amount_4, Amount_5_Title as Month_5, Amount_5,
Amount_6_Title as Month_6, Amount_6, Amount_7_Title as Month_7, Amount_7,
Amount_8_Title as Month_8, Amount_8, Amount_9_Title as Month_9, Amount_9,
Amount_10_Title as Month_10, Amount_10, Amount_11_Title as Month_11, Amount_11,
Amount_12_Title as Month_12, Amount_12, Amount_13_Title as Total, Amount_13 as Total_Amount
parameters DateMacro = 'ThisYear', SummarizeColumnsBy = 'Month',
ClassFilterFullNameWithChildren='New Construction'

Try 'Store I:Retail' and use:

SP_PARAMETERS ProfitAndLossBudgetOverview

or the report you're interested in, to list all the parameters available for use in the report. Often it's better to play with the report you are trying to do using the QuickBooks user interface first.

For just the Data rows of a report just use:

sp_report ProfitAndLossByClass show Label, Amount
parameters DateMacro = 'ThisYearToDate',
SummarizeColumnsBy = 'Class'
where RowType = 'DataRow'