LobbyCentral Data Source=192.167.15.109;Integrated Security=True;Initial Catalog=lobbyCentral_dev LobbyCentral ReportData employeeName,System.String timeSeen,System.DateTime timeOut,System.DateTime locationID,System.Int32 locationName,System.String serviceName,System.String requestID,System.Int32 30 False ReportData LobbyCentral _x0040_startDate,,4,0 _x0040_endDate,,4,0 _x0040_locationID,,8,0 _x0040_userID,,8,0 SELECT R.requestID, (U.firstName + ' ' + U.lastName) AS employeeName, RT.timeSeen,RT.timeOut, L.locationID, L.locationName, CASE RS.serviceID WHEN -1 THEN RS.serviceDescOvrd ELSE S.serviceName END AS serviceName FROM tblRequest AS R LEFT JOIN tblRequestTicket AS RT ON RT.requestID = R.requestID LEFT JOIN tblRequest_Service AS RS ON (RS.requestID = R.requestID AND RS.ordinal = 0) LEFT JOIN tblUser AS U ON U.userID= RT.userID LEFT JOIN tblCustomer AS C ON C.customerID=R.customerID LEFT JOIN tblQueue AS Q ON Q.queueID=R.queueID LEFT JOIN tblLocation AS L on L.locationID = Q.locationID LEFT JOIN tblService AS S ON S.serviceID = RS.serviceID WHERE R.requestID IN (SELECT TOP 1 requestID FROM tblRequestTicket WHERE requestID=R.requestID AND ticketAction <> 5 AND Convert(char, timeout, 101) >= @startDate AND Convert(char, timeout, 101) <= @endDate ORDER BY timeSeen desc) AND (R.status = 2) AND (Q.locationID=@locationID or @locationID=0) AND ((RT.ticketAction = 1 AND RT.userID = @userID) or @userID=0) ORDER BY L.locationName, serviceName LocationSource locationID,System.Int32 locationName,System.String 30 False LocationSource LobbyCentral select locationID, locationName from tblLocation order by locationName UserSource userID,System.Int32 userFullname,System.String 30 False UserSource LobbyCentral select userID, (firstName + ' ' + lastName) as userFullname from tblUser order by userFullname EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.2,7.49,1.1 Transparent 0.2,0.1,2.8,0.2 Arial,12,Bold 0,0,0,0 Text1 Service Requests by Employee Black Transparent 0.2,0.4,7,0.2 Arial,10 26e36e903d014ad8aac4b08693f9057f 0,0,0,0 Text2 Date: {string.Format("{0:d}",ReportData.Parameters["@startDate"].ParameterValue)} - {string.Format("{0:d}",ReportData.Parameters["@endDate"].ParameterValue)} Black Transparent 0.2,0.8,3.6,0.2 Arial,10,Bold| Italic 5e3bd2d967854280abe01cd10016050a 0,0,0,0 Text57 {ReportData.Count == 0?"No data found":""} [237:28:36] ReportTitle1 Transparent 0,1.7,7.49,0.3 LightGray 0,0,7.5,0.2 Arial,12,Bold 0,0,0,0 Text3 {ReportData.locationName} Black {ReportData.locationID} GroupHeader1 Transparent 0,2.4,7.49,0.3 Transparent 0.2,0,2.6,0.2 Arial,10,Bold 0,0,0,0 Text4 {ReportData.serviceName} Black Transparent 3.3,0,0.8,0.2 Arial,10,Bold 0,0,0,0 Text6 Handled Black Transparent 4.2,0,1.2,0.2 Arial,10,Bold 0,0,0,0 Text7 Avg. Service Time Black {ReportData.serviceName} GroupHeader2 Transparent 0,3.1,7.49,0 {ReportData.employeeName} GroupHeader3 Transparent 0,3.5,7.49,0 ReportData Data1 Transparent 0,3.9,7.49,0.3 Transparent 0.5,0,2.3,0.2 Arial,10 0,0,0,0 Text5 {ReportData.employeeName} Black Transparent 3.3,0,0.8,0.2 Arial,10 0,0,0,0 Text8 {Count(Data1,ReportData.requestID)} Black Transparent 4.2,0,1.2,0.2 Arial,10 Right 0,0,0,0 Text9 {GetFormattedTime(CalcAvg(CountDistinct(Data1,ReportData.requestID) ,Sum(Data1, CalcTime(ReportData.timeOut, ReportData.timeSeen))))} Black GroupFooter3 Transparent 0,4.6,7.49,0.1 GroupFooter2 Transparent 0,5.1,7.49,0 GroupFooter1 a79bec70c4d14694ade8082cfe52266b 0.39,0.39,0.39,0.39 Page1 11.69 8.27 Arial,100 [50:0:0:0] Control ReportData.Parameters["@startDate"].ParameterValue = startDate.Value.ToString("MM/dd/yyyy"); ReportData.Parameters["@endDate"].ParameterValue = endDate.Value.ToString("MM/dd/yyyy"); int locationID = 0; int userID = 0; if (lstLocation.SelectedIndex > 0) { int index = lstLocation.SelectedIndex; index--; int.TryParse(LocationSource.GetData("locationID", index).ToString() ,out locationID); } if (lstUser.SelectedIndex > 0) { int index = lstUser.SelectedIndex; index--; int.TryParse(UserSource.GetData("userID", index).ToString() ,out userID); } ReportData.Parameters["@locationID"].ParameterValue = locationID; ReportData.Parameters["@userID"].ParameterValue = userID; ReportData.Connect(); 16,152,96,24 True OK Microsoft Sans Serif,8 Black eacad717973a420dbcfc87e978b1a15d 16, 152 Button2 96, 24 Run Report Control 16,8,64,16 Microsoft Sans Serif,8,Bold Black 8ef5fee54175455dbb40104a74299eea 16, 8 Label2 64, 16 Start Date: Control 120,8,64,16 Microsoft Sans Serif,8,Bold Black c30afc0d592c419b90bef95d282b673d 120, 8 Label1 64, 16 End Date: Window 16,24,88,20 Microsoft Sans Serif,8 Black Short fd5e244800bf4b69aeaac6799ffad8c2 16, 24 12/31/9998 12:00:00 AM 1/1/1753 12:00:00 AM startDate 88, 20 12/9/2008 12:00:00 AM Window 120,24,88,20 Microsoft Sans Serif,8 Black Short 78b2afaf9603445098d5c580451886d7 120, 24 12/31/9998 12:00:00 AM 1/1/1753 12:00:00 AM endDate 88, 20 12/9/2008 12:00:00 AM Control 16,56,112,16 Microsoft Sans Serif,8,Bold Black 78a494c48d1f441aa83aab9641d02dd5 16, 56 Label3 112, 16 Report by Location: Window 16,72,200,20 DropDownList Microsoft Sans Serif,8 Black c698e8ce751f42d3919317679bfd8336 16, 72 lstLocation 200, 20 Combo Box Control 16,104,112,16 Microsoft Sans Serif,8,Bold Black d70f323c87d6451eadd6d650e843a12f 16, 104 Label5 112, 16 User: Window 16,120,144,20 DropDownList Microsoft Sans Serif,8 Black 36eeeda1a92d43189801ce695971c94f 16, 120 lstUser 144, 20 Combo Box Microsoft Sans Serif,8 582f0d1083f047a98340c101223823f9 if (!formLoaded) { InitForm(); startDate.Value = DateTime.Now; endDate.Value = DateTime.Now; } 0, 0 Form1 408, 232 Service Requests by Employee System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Service Requests by Employee FSi 8/14/2011 6:51:57 PM 5/6/2010 10:11:31 AM A summary report for each service that was completed, detailed by employee, the number of occurances, and the average service time. U:\Fuhr Software\Release Builds\LobbyCentral\Reports\Reports\ServiceReqByEmp.mrt dea00d9fb5d5427ba24ff6c06410e14c Service Requests by Employee Inches 2011.3.1200 CSharp