Thanks for the links guys.

Phil.

I can get it to run if I make the user account a domain admin (which I do not want to do).

What are the minimum permissions?

Phil.

Hi. You need to reference a field that exists within the report body (which can be hidden)i.e.

= First(ReportItems!YourField.Value)

Regards,

Phil.

Thanks, I will take a look.

Phil.

Chris many thanks for your efforts, I will wrap my brain around your example and attempt to adopt this approach.

Many Thanks,

Phil.

Thanks Seth,I will read your post.

Many Thanks,

Phil.

Thanks Seth. Quite new to SQL. Should I simply script the tables that appear in any query (strip out constraints)? Regards the INSERT I have only ever done INSERT FROM...

I have resolved (I think) by adding additional grouping on the report.

grpQty (by quantity,ProductCode)

If anyone has an opinion on the code etc please feel free to educate me!

Thanks,

Phil.

Sankar just what I was after.

Many Thanks,

Phil.

Hi NULL, sorry for the delay in posting back.

I made the amendment but the query still returned multiple rows for the same product rather than count.

Thanks for all your efforts,...

Adi thanks for the reply, I have re-attached as .xls.

I have modified code as follows:

SELECT

YEAR (so.EffectiveDate) AS Year,

MONTH (so.EffectiveDate)AS Month,

COUNT(so.SalesOrder)AS NumberOfQuotes,

SUM (si.CurItemValue) AS OrderTotal

FROM SalesOrders so

INNER JOIN SalesOrderItems si...

Thanks guys. I will need to check with the app vender.

It has come to light that I may be able to get what I am after by extracting from...

NULL I will give that a try then update.

Many Thanks,

Phil.

Hi Ramesh. Having reveiwed the orders from within the existing system it came to light that what I thought was the last OrderId was not in fact the case, they...

I have run the following query (small sample of output attached).

SELECT ProductId

,COUNT(1) OrderCount

,CASE WHEN COUNT(1) = 1 THEN SUM(MAN)/NULLIF(MANCount,0) ELSE AVG(MAN) END MAN

,CASE WHEN...