Transaction Count Report by Register

(0) Share

Report

Posted on by Community Member Microsoft Employee

A customer of ours is looking for a report that will show the number of transactions per register by hour. I looked through the report library and the forum and couldn't find anything that fit that bill

*This post is locked for comments

All responses (5)

Answers (0)

Suggested answer

archelle16 1,735 on at

Like (0)

Report

RE: Transaction Count Report by Register

Hello. email me at archelle.pagapulan@outlook.com. I'll send you one.
Tom Lansing 5 on at

Like (0)

Report

RE: Transaction Count Report by Register

# of transactions show in the hourly breakdown on the bottom of the standard X and Z reports
Community Member Microsoft Employee on at

Like (0)

Report

RE: Transaction Count Report by Register

If u r familiar with customizing RMS reports then it would be easy to base a report on this query by creating a view then make the RMS report use this view
Community Member Microsoft Employee on at

Like (0)

Report

RE: Transaction Count Report by Register

Well this would be something the end user would be using so I don't really want them running SQL queries. I was hoping to get a report they could run in manager.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Transaction Count Report by Register

The below query would do it for you, you can activate the commented line in case you want to exclude the returns transaction (typically excluded if the purpose is to get the customers count)

select register.description, datepart(hour,time) as DayHour,count(*) as TransCount

from [transaction] inner join batch on [transaction].batchnumber=batch.batchnumber

inner join register on register.id=registerid

where CONVERT(datetime, CONVERT(nvarchar, time, 101), 101)='2014-01-14'

--and total>0

group by register.description, datepart(hour,time)

order by 1,2

A Hassan

RMS Leaders