Standard Report - Order Report

Report Description

Shows basic order information for all active orders within a specified date range.

Parameters

Parameter Name	Options	Explanation
Customer Name		Filters results by Customer Name.
Group By	Branch, User, Customer, Order Status,Order ID
User Type	All Available user types based on temp and DH user.
User	All Active and Visible User Names
Order Type	All Temp & DH Order types
Branch	All available branches
Show Open Order Graph	True or False	If "Show open order graph" is set to "True" then it displays a bar graph which shows the number of order vs. user (username from master user with user type selected in user type parameter).
Order Status	All Temp & DH Order status.
Start Date
End Date

Report Fields

Field Name	Explanation
Order ID	Pulls staffingorderID from staffing order. Will visible when group by parameter is selected as Order ID.
Order Date	Pulls startdate from orderschedule. Will visible when group by parameter is selected as Order ID.
Type	All Temp & DH Order types Will be blank when group by parameter is selected as Branch. Will be blank when group by parameter is selected as User. Will be blank when group by parameter is selected as Customer. Will be blank when group by parameter is selected as Order Status.
Job Title	Pulls skillcode form configwccode. Will be blank when group by parameter is selected as Branch. Will be blank when group by parameter is selected as User. Will be blank when group by parameter is selected as Customer. Will be blank when group by parameter is selected as Order Status.
R#	Number of job required.
P#	Number of job Placed
Pay Rate	Pulls payrate from orderrate with paycode Reg. Will be blank when group by parameter is selected as Branch. Will be blank when group by parameter is selected as User. Will be blank when group by parameter is selected as Customer. Will be blank when group by parameter is selected as Order Status. Will be blank when group by parameter is selected as Order Status.
Bill Rate	Pulls bilrate from orderrate with paycode Reg. Will be blank when group by parameter is selected as Branch. Will be blank when group by parameter is selected as User. Will be blank when group by parameter is selected as Customer. Will be blank when group by parameter is selected as Order Status.
Supervisor	Pulls contact name from contact role of order whose role is supervisor. Will be blank when group by parameter is selected as Branch. Will be blank when group by parameter is selected as User. Will be blank when group by parameter is selected as Customer. Will be blank when group by parameter is selected as Order Status.
Contact Method	Pulls primary contact method of supervisor àorder contact àorder contact role with role supervisor. Will be blank when group by parameter is selected as Branch.
Branch	Pulls the order’s branch Will visible when group by parameter is selected as Branch.
No. Of orders	Counts the number of orders. Will visible when group by parameter is selected as Branch. Will visible when group by parameter is selected as User. Will visible when group by parameter is selected as Customer. Will visible when group by parameter is selected as Order Status.
User	Pulls username from master user with user type selected in user type parameter. Will visible when group by parameter is selected as User.
Customer	Pulls customer name from customer in which order was created. Will visible when group by parameter is selected as Customer.
Order Status	Pulls status of order. Will visible when group by parameter is selected as Order Status.