I'm trying to generate a p&l report that looks like the following for a given fiscal year:

Class Account# AccountName Month MonthlyAmount

G&A       100        Salaries            Jan         3000

G&A       100        Salaries            Feb         4000

Sales     200       Comm               Jan         1000

Sales     200       Comm               Feb         2000

......

Essentially, just a dump of data.  Thanks!

Try looking at the examples shown in:
Profit & Loss Summary Report by Class 
How do I run a Profit & Loss Standard Report? 
and  Profit & Loss by class with natural trial balance sign ... help! 

For just the Data rows of any report just use: where RowType = 'DataRow' for example:-

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

Thanks for the quick response.  I've looked at, and ran the code, against the database for all of the links provided.

Essentially, I am trying to "normalize" the output.

In a simple example,

AccountName Month1 Month2 Month3 Month4

G&A                      500       600      700       600

Will turn to

AccountName Month Amount

G&A                  Month1  500

G&A                  Month2  600

G&A                  Month3  700

G&A                  Month4  600

This will be used as part of a budgeting process where monthly budgets are compared to each other and to actual.  I import the budget excel spreadsheets in access then normalize using union queries.

I could try to normalize the actual data after by doing a bunch of union queries, I suppose, but it would be much, much easier if the output were initally normalized to

Class Account# AccountName Month MonthlyAmount

You can do it, but you would need to run the report for each class your interested one at a time 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'

Thanks again for the quick response!  I ran that, and it generated (roughly)

Class Month1 Month1Amount Month2 Month2Amount Month3 Month3Amount

What i am trying to get is:

Class Month MonthAmount

            Month1 Month1Amount

           Month2 Month2Amount

           Month3 Month3Amount

So, lots and lots of rows, but only three columns (in this case)