LobbyCentral Data Source=192.167.15.102;Integrated Security=True;Initial Catalog=santa_clarita LobbyCentral ReportData requestID,System.Int32 customerID,System.Int32 dateCreated,System.DateTime createdBy,System.Int32 timeIn,System.DateTime status,System.Int32 queueID,System.Int32 originatingRequestID,System.Int32 requestedUserID,System.Int32 note,System.String accountID,System.Int32 counterID,System.Int32 ticketNumber,System.Int32 scheduledDate,System.DateTime workTimeDur,System.Int32 notifySMS,System.Boolean reqServID,System.Int32 requestID1,System.Int32 serviceID,System.Int32 serviceDescOvrd,System.String ordinal,System.Int32 userFirstName,System.String userLastName,System.String firstName,System.String lastName,System.String custName,System.String ticketID,System.Int32 requestID2,System.Int32 userID,System.Int32 timeSeen,System.DateTime timeOut,System.DateTime comments,System.String queueID1,System.Int32 ticketAction,System.Int32 locationName,System.String serviceName,System.String accountNumber,System.String queueName,System.String locationID,System.Int32 30 False ReportData LobbyCentral _x0040_locationID,,8,0 _x0040_startDate,,4,0 _x0040_endDate,,4,0 SELECT R.*, RS.*, U.firstName AS userFirstName, U.lastName AS userLastName, C.firstName, C.lastName, (C.firstName + ' ' + C.lastName) as custName, RT.*, L.locationID, L.locationName, S.serviceName, A.accountNumber, Q.queueName 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 LEFT JOIN tblAccount AS A ON A.accountID = R.accountID 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 <> 0 AND R.status <> 1 AND Q.queueType = 0 AND (RT.ticketAction = 1 OR (RT.ticketAction=4 AND RT.timeSeen > '1/1/1900')) AND (Q.locationID = @locationID OR @locationID=0) ORDER BY L.locationName, R.timeIn 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 ,varUser,varUser,System.Int32,,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.2,10.91,1.2 Transparent 0.1,0.1,9.5,0.3 Arial,14.25,Bold 93e305cfe41d43579096fc8be01fe0c4 0,0,0,0 Text1 Lobby Service Request Activity Black Expression Transparent 0.1,0.5,7,0.2 Arial,10 1287d28feb274b9986ec61a95fdbac72 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.1,0.9,3.6,0.2 Arial,10,Bold| Italic 0,0,0,0 Text57 {ReportData.Count == 0?"No data found":""} [237:28:36] ReportTitle1 Transparent True 0,1.8,10.91,0.9 Transparent 0.1,0.1,5.2,0.2 Arial,12,Bold 0,0,0,0 Text3 Location: {ReportData.locationName} Black Transparent 0.3,0.4,10.6,0.4 Transparent 0,0.1,0.8,0.2 Arial,10,Bold e377c03e79684687829842d5444cd2da 0,0,0,0 Text24 Request ID Black Transparent 0.9,0.1,2,0.2 Arial,10,Bold be987464c23f4398b132e60fecbc7823 0,0,0,0 Text25 Customer Black Transparent 3,0.1,0.8,0.2 Arial,10,Bold dad35dd03803431ba95d081852a6efb5 0,0,0,0 Text26 Date In Black Transparent 4.7,0.1,0.6,0.2 Arial,10,Bold c06b32ff6b4f40b7b5b959502dbc8068 Center 0,0,0,0 Text27 Assisted Black Transparent 3.9,0.1,0.7,0.2 Arial,10,Bold 0ab280f66df2463789476874ca2589cd Center 0,0,0,0 Text28 Arrived Black Transparent 5.4,0.1,0.7,0.2 Arial,10,Bold c0d817271a0248f6a2311eaacc2d43f3 Center 0,0,0,0 Text29 Departed Black Transparent 6.2,0,0.7,0.3 Arial,10,Bold 43f6f02e6b2c4c84aac62a5fc6de13a8 Center 0,0,0,0 Text30 Length of Wait Black Transparent 7,0,0.7,0.3 Arial,10,Bold 971e31a613354df38637632d6f377b26 Center 0,0,0,0 Text31 Length of Service Black Transparent 7.8,0.1,1.5,0.2 Arial,10,Bold 22720a60d2eb48f0ab9fbe67a0d17fb9 0,0,0,0 Text32 Service Black Transparent 9.4,0.1,1.1,0.2 Arial,10,Bold 14f95f4a2dab4b82b61de4c0167b4946 0,0,0,0 Text65 Completed Black 93de769088f147b18ef35fd6fa5e3e37 Panel_Location {ReportData.locationID} False GroupHeader_Location Transparent True 0,3.1,10.91,0.8 Transparent 0.3,0.1,5.2,0.2 Arial,10,Bold 37cbb24548564723ba310d9eee2e76eb 0,0,0,0 Text4 Service Queue: {ReportData.queueName} Black Transparent 0.3,0.4,10.6,0.4 Transparent 0,0.1,0.8,0.2 Arial,10,Bold 0d17cdf5f8114c4f80f891f58287fc86 0,0,0,0 Text5 Request ID Black Transparent 0.9,0.1,2,0.2 Arial,10,Bold 199e052535404479b3521261fd8ff44a 0,0,0,0 Text6 Customer Black Transparent 3,0.1,0.8,0.2 Arial,10,Bold 0d2aedca74104bd892a51b5ed1570f5d 0,0,0,0 Text7 Date In Black Transparent 4.7,0.1,0.6,0.2 Arial,10,Bold df9a4d47e2a644e086c41e1bd080e6db Center 0,0,0,0 Text8 Assisted Black Transparent 3.9,0.1,0.7,0.2 Arial,10,Bold 7365458e8f7b44e6b3a7ce685d355ceb Center 0,0,0,0 Text9 Arrived Black Transparent 5.4,0.1,0.7,0.2 Arial,10,Bold b987604208104a2d924f46ce75831e58 Center 0,0,0,0 Text10 Departed Black Transparent 6.2,0,0.7,0.3 Arial,10,Bold 9b0088be6d2949fa85ab16464f5262b1 Center 0,0,0,0 Text11 Length of Wait Black Transparent 7,0,0.7,0.3 Arial,10,Bold 256f4ff7b3784520b7cad2f73ba9e6b5 Center 0,0,0,0 Text12 Length of Service Black Transparent 7.8,0.1,1.5,0.2 Arial,10,Bold 634eda2d61b14dc3a90e0057d87b0104 0,0,0,0 Text13 Service Black Transparent 9.4,0.1,1.1,0.2 Arial,10,Bold d2d1f404358846938e4f00680ddc5026 0,0,0,0 Text64 Completed Black Panel_Queue {ReportData.queueID} GroupHeader_Queue Transparent 0,4.3,10.91,0 {Format("{0:MM/dd/yyyy}", ReportData.timeIn)} False GroupHeader_Date Transparent True 0,4.7,10.91,0.9 Transparent 0.3,0.1,5.2,0.2 Arial,10,Bold e9c94f8dbecc41bf9f557b038de23534 0,0,0,0 Text22 User: {ReportData.userFirstName} {ReportData.userLastName} Black Transparent 0.3,0.4,10.6,0.4 Transparent 0,0.1,0.8,0.2 Arial,10,Bold dfb9de2ef34640ae837b5ec7605452b3 0,0,0,0 Text33 Request ID Black Transparent 0.9,0.1,2,0.2 Arial,10,Bold 7575a9cbde494249ad0949116971387f 0,0,0,0 Text34 Customer Black Transparent 3,0.1,0.8,0.2 Arial,10,Bold 00018cf9f0934d48977596d3d5b11ddf 0,0,0,0 Text35 Date In Black Transparent 4.7,0.1,0.6,0.2 Arial,10,Bold f953bd68f1474bd7b9b73d4a50050641 Center 0,0,0,0 Text36 Assisted Black Transparent 3.9,0.1,0.7,0.2 Arial,10,Bold 50c5c6fc499a4be98a55ad07aa454a20 Center 0,0,0,0 Text37 Arrived Black Transparent 5.4,0.1,0.7,0.2 Arial,10,Bold e80156d2e09548d9ab2e5051927f4593 Center 0,0,0,0 Text38 Departed Black Transparent 6.2,0,0.7,0.3 Arial,10,Bold 82c59306a064481b91ecb000fe50403d Center 0,0,0,0 Text39 Length of Wait Black Transparent 7,0,0.7,0.3 Arial,10,Bold 1ffadd17b02c47ca9522d366035189db Center 0,0,0,0 Text40 Length of Service Black Transparent 7.8,0.1,1.5,0.2 Arial,10,Bold 1e1d9ddc12574bdd9a5bdb5bc442f5a7 0,0,0,0 Text41 Service Black Transparent 9.4,0.1,1.1,0.2 Arial,10,Bold dd85f1a361274190b28e62475697abe7 0,0,0,0 Text63 Completed Black 8a830d14b41d4a688888d37ed4774265 Panel_User {ReportData.userID} False GroupHeader_User Transparent True 0,6,10.91,0.4 Transparent 0.3,0.1,0.6,0.2 Arial,10 0,0,0,0 Text14 {ReportData.requestID} Black Transparent 1.2,0.1,2,0.2 Arial,10 0,0,0,0 Text15 {ReportData.custName} {IIF(ReportData.ticketAction == 4,"(Abandoned)","")} Black Transparent 3.3,0.1,0.8,0.2 Arial,10 0,0,0,0 Text16 {Format("{0:MM/dd/yyyy}", ReportData.timeIn)} Black Transparent 4.2,0.1,0.7,0.2 Arial,10 Right 0,0,0,0 Text17 {Format("{0:hh:mm tt}", ReportData.timeIn)} Black Transparent 5,0.1,0.6,0.2 Arial,10 4c25666aeef74b11b4ccff314302e6ef Right 0,0,0,0 Text18 {Format("{0:hh:mm tt}", ReportData.timeSeen)} Black Transparent 5.7,0.1,0.7,0.2 Arial,10 7803acd7a9f54d2ea0912ebc3a6779c3 Right 0,0,0,0 Text19 {Format("{0:hh:mm tt}", ReportData.timeOut)} Black Transparent 6.5,0.1,0.7,0.2 Arial,10 Right 0,0,0,0 Text20 {GetFormattedTime(Sum(Data1, CalcTime(ReportData.timeSeen, ReportData.timeIn)))} Black Transparent 8.1,0.1,1.5,0.2 Arial,10 0,0,0,0 Text21 {IIF(ReportData.serviceID > 0,ReportData.serviceName,ReportData.serviceDescOvrd)} Black Expression Transparent 9.7,0.1,1.1,0.2 Arial,10 0,0,0,0 txtCompletedBy {ReportData.userFirstName} {ReportData.userLastName} Black Transparent 7.3,0.1,0.7,0.2 Arial,10 b8b29d858245439fa4772b8975ce102f Right 0,0,0,0 Text23 {GetFormattedTime(Sum(Data1, CalcTime(ReportData.timeOut, ReportData.timeSeen)))} Black {ReportData.originatingRequestID} GroupHeader_Data Transparent 0,6.8,10.91,0 ReportData _x007B_ReportData.userID_x0020__x003D__x003D__x0020__x0028__x0028_varUser_x0020__x003D__x003D__x0020_0_x0029__x0020__x003F__x0020_ReportData.userID_x0020_:_x0020_varUser_x0029__x007D_ Data1 Transparent 0,7.2,10.91,0 GroupFooter_Data Transparent 0,7.6,10.91,0.7 Transparent 3.7,0.1,2.8,0.2 Arial,10,Bold 98730858866442b9b50decf200703f79 Right 0,0,0,0 Text52 {ReportData.userFirstName} {ReportData.userLastName} Totals: Black Transparent 6.6,0.1,0.6,0.2 Arial,10 9615842f2892431da58ec3257d120749 Right 0,0,0,0 Text53 {GetFormattedTime(Sum(Data1, CalcTime(ReportData.timeSeen, ReportData.timeIn)))} Black Transparent 7.3,0.1,0.7,0.2 Arial,10 37c39843b5204b5e81ed750ebfd995f8 Right 0,0,0,0 Text54 {GetFormattedTime(Sum(Data1, CalcTime(ReportData.timeOut, ReportData.timeSeen)))} Black Transparent 5.3,0.4,1.2,0.2 Arial,10,Bold cc068a170b384158924b43e18da591a2 Right 0,0,0,0 Text55 Total Requests: Black Transparent 6.6,0.4,0.6,0.2 Arial,10,Bold 824cf30e13fb49f692c29d7e95fe8183 Right 0,0,0,0 Text56 {CountDistinct(Data1, ReportData.requestID)} Black False GroupFooter_User Transparent 0,8.7,10.91,0.7 Transparent 3.7,0.1,2.8,0.2 Arial,10,Bold 3a4606f749a34b498a448a3ebffe97d7 Right 0,0,0,0 Text58 {Format("{0:MM/dd/yyyy}", ReportData.timeIn)} Totals: Black Transparent 6.6,0.1,0.6,0.2 Arial,10 87c1e96b4a154a569d5194a242d96f85 Right 0,0,0,0 Text59 {GetFormattedTime(Sum(Data1, CalcTime(ReportData.timeSeen, ReportData.timeIn)))} Black Transparent 7.3,0.1,0.7,0.2 Arial,10 a2600f83705d41099c7ebf034fa827e2 Right 0,0,0,0 Text60 {GetFormattedTime(Sum(Data1, CalcTime(ReportData.timeOut, ReportData.timeSeen)))} Black Transparent 5.3,0.4,1.2,0.2 Arial,10,Bold f61b0e2509c94714819477d0abf35f8e Right 0,0,0,0 Text61 Total Requests: Black Transparent 6.6,0.4,0.6,0.2 Arial,10,Bold cd50822c9bcc40f69182c1b113eff2a0 Right 0,0,0,0 Text62 {CountDistinct(Data1, ReportData.requestID)} Black False GroupFooter_Date Transparent 0,9.8,10.91,0.7 Transparent 3.7,0.1,2.8,0.2 Arial,10,Bold a78b583548114d17958166e5a17fe781 Right 0,0,0,0 Text47 {ReportData.queueName} Totals: Black Transparent 6.6,0.1,0.6,0.2 Arial,10 deb9f724b2af47d5ad393ec578cc7bbd Right 0,0,0,0 Text48 {GetFormattedTime(Sum(Data1, CalcTime(ReportData.timeSeen, ReportData.timeIn)))} Black Transparent 7.3,0.1,0.7,0.2 Arial,10 0a0eee42317446d3bb52035ee5880bf7 Right 0,0,0,0 Text49 {GetFormattedTime(Sum(Data1, CalcTime(ReportData.timeOut, ReportData.timeSeen)))} Black Transparent 5.3,0.4,1.2,0.2 Arial,10,Bold 7c1f378936d049be95ea633781a224eb Right 0,0,0,0 Text50 Total Requests: Black Transparent 6.6,0.4,0.6,0.2 Arial,10,Bold bc3e08dd91034dd0bd74aae1a39064fb Right 0,0,0,0 Text51 {CountDistinct(Data1, ReportData.requestID)} Black GroupFooter_Queue Transparent 0,10.9,10.91,0.8 Transparent 3.7,0.1,2.8,0.2 Arial,10,Bold Right 0,0,0,0 Text44 {ReportData.locationName} Totals: Black Transparent 6.6,0.1,0.6,0.2 Arial,10 Right 0,0,0,0 Text45 {GetFormattedTime(Sum(Data1, CalcTime(ReportData.timeSeen, ReportData.timeIn)))} Black Transparent 7.3,0.1,0.7,0.2 Arial,10 Right 0,0,0,0 Text42 {GetFormattedTime(Sum(Data1, CalcTime(ReportData.timeOut, ReportData.timeSeen)))} Black Transparent 5.3,0.4,1.2,0.2 Arial,10,Bold Right 0,0,0,0 Text43 Total Requests: Black Transparent 6.6,0.4,0.6,0.2 Arial,10,Bold Right 0,0,0,0 Text46 {CountDistinct(Data1, ReportData.requestID)} Black False GroupFooter_Location b811b496fe4b4d4ab9ef8f9a40b29021 True 0.39,0.39,0.39,0.39 Page1 Landscape 8.27 11.69 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; int queueID = 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; if (groupQueue.Checked || groupUser.Checked ) { Panel_Location.Enabled = false; } else { Panel_Location.Enabled = true; } if (groupQueue.Checked) { GroupHeader_Queue.Enabled = true; GroupFooter_Queue.Enabled = true; Panel_Queue.Enabled = true; } else { GroupHeader_Queue.Enabled = false; GroupFooter_Queue.Enabled = false; Panel_Queue.Enabled = false; } if (groupDate.Checked) { GroupHeader_Date.Enabled = true; GroupFooter_Date.Enabled = true; } else { GroupHeader_Date.Enabled = false; GroupFooter_Date.Enabled = false; } if (groupUser.Checked) { GroupHeader_User.Enabled = true; GroupFooter_User.Enabled = true; txtCompletedBy.Enabled = false; Panel_User.Enabled = true; Panel_Queue.Enabled = false; } else { GroupHeader_User.Enabled = false; GroupFooter_User.Enabled = false; Panel_User.Enabled = false; } varUser = userID; ReportData.Connect(); 264,224,96,24 True OK Microsoft Sans Serif,8 Black 006f725690b246ba962ea24e545455bd 264, 224 Button2 96, 24 Run Report Control True 24,184,96,24 Microsoft Sans Serif,8 Black 24, 184 groupQueue 96, 24 by Queue Control 112,184,96,24 Microsoft Sans Serif,8 Black 112, 184 groupDate 96, 24 by Date Control 192,184,96,24 Microsoft Sans Serif,8 Black 192, 184 groupUser 96, 24 by User Control 8,160,96,16 Microsoft Sans Serif,8,Bold Black 8, 160 Label6 96, 16 Group Options: Control 16,16,64,16 Microsoft Sans Serif,8,Bold Black 156446d899f44c53a7f7fee0edf6b4ce 16, 16 Label2 64, 16 Start Date: Control 16,64,64,16 Microsoft Sans Serif,8,Bold Black b6ea560de48b4788841b27601b39351e 16, 64 Label1 64, 16 End Date: Window 16,32,88,20 Microsoft Sans Serif,8 Black Short c8fca311520e4cbeba213aa2285ba267 16, 32 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 16,80,88,20 Microsoft Sans Serif,8 Black Short fe50e449b0224441ad8378f21f195425 16, 80 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 136,16,112,16 Microsoft Sans Serif,8,Bold Black d74d5c2cd3c045699d278d99dc4a5e9b 136, 16 Label3 112, 16 Location: Window 136,32,200,20 DropDownList Microsoft Sans Serif,8 Black 1ef5f295c49045b2868bc900edbdf41f 136, 32 lstLocation int locationID = 0; if (lstLocation.SelectedIndex > 0) { int index = lstLocation.SelectedIndex; index--; int.TryParse(LocationSource.GetData("locationID", index).ToString() ,out locationID); } 200, 20 Combo Box Control 136,64,112,16 Microsoft Sans Serif,8,Bold Black 8078e599b02c446586e3f6cb7123d8eb 136, 64 Label5 112, 16 User: Window 136,80,200,20 DropDownList Microsoft Sans Serif,8 Black 4fc7907fbefe4223a60101cabd1e6ea6 136, 80 lstUser 200, 20 Combo Box Microsoft Sans Serif,8 f36b3c2318e3400b9b2f3ecd008ac401 if (!formLoaded) { InitForm(); startDate.Value = DateTime.Now; endDate.Value = DateTime.Now; } 0, 0 Form1 376, 288 Service Request Activity 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 Request Transactions FSi 6/23/2013 10:16:43 AM 11/25/2009 8:29:07 AM A detailed listing of service requests completed for a specific date range C:\dev\LobbyCentral\LobbyCentral ServiceCenter Web\v6.0\ServiceCenter Web\reports\reportManager\files\Reports\serviceRequestActivity.mrt ec6ad38309204442bedca8e8d9505855 Service Request Transactions Inches 2011.2.1100 CSharp