Anyone have these reports?

Hi Gaz - I don't have them in reports, but oddly I was working on these scenarios for testing purposes using sql queries, maybe you can use these until someone posts the qrp files you need...the second query may not be what you are looking for , I'm setting it up as an average transaction by register (with and without customers assigned to the transaction)

select department.name AS DEPARTMENT, sum(transactionentry.quantity) AS TOTAL_QTY_SOLD, sum(transactionentry.quantity*transactionentry.price) as REVENUE from transactionentry left join [transaction] on transactionentry.transactionnumber [transaction].transactionnumber left join item on transactionentry.itemid = item.id left join department on department.id = item.departmentid where [transaction].time between '12/01/2007' and '12/05/2007' group by department.name

-- date after "and" will not be included in calculations --

select register.descripti> Value and quantity of Items purchased by supplier over a defined period and

Thanks convoluted

I actually wanted the average sale per tranascti> Hi Gaz - I don't have them in reports, but oddly I was working on these

Hi Gaz,

Retail Analytics for Microsoft RMS is designed to help retailers manage their business by delivering analytical reporting on business performance. Easily identify trends, buying patterns, seasonality, and other key performance indicators for your business.

If you enter it in RMS you can report on it in Retail Analytics.

If you would like to take a look at it -

Thanks,

Jen Bridgeford Professional Advantage

"Gaz" wrote:

Hi Gaz,

That is strange as I just tried it and it worked.

Thanks,

Jen

"Gaz" wrote: