It works just like I wanted it to. Thank you.

It looks correct now.

I have access to 2012 for me to look at the report file and then recreate it in 2008.

That is very close. The sales rep total line should be the total of the sales not the gross margin. Other than that the report looks like it should. I...

Thank you for the link. Here is some sample data.

IF OBJECT_ID('TempDB..tblSales','U') IS NOT NULL

DROP TABLE tblSales

CREATE TABLE tblSales

(

ID int IDENTITY(1,1) PRIMARY KEY CLUSTERED,

SalespersonRep nvarchar(255),

CustomerName nvarchar(255),

InvoiceDate datetime,

InvoiceLineAmount float,

COGSAmount float

)

SET DATEFORMAT DMY

SET...

Thank you pietlinden.

The Cost and Gross Margin which are to be shown under the Sales are missing. How would you add those in?