true Data Source=CRM;Initial Catalog=AWC4_Log SQL 720b0bcd-6eb0-4c1f-85c4-ba3af845ef27 2.5cm 2.5cm 21cm true 8.5in 0.25cm true 1cm textbox1 1 true 0.91429cm Log By Date And User - Last 7 days 1.35cm 2.53968cm DateText 3 true =Fields!DateText.Value textbox5 true Total =Fields!DateYYYYMMDD.Value Descending =Fields!DateText.Value 4.5cm username 2 true =Fields!username.Value =Fields!username.Value Ascending =Fields!username.Value TimePeriod 5 true =Fields!TimePeriod.Value textbox4 4 true Total =Fields!TimePeriod.Value Ascending =Fields!TimePeriod.Value 0.53333cm IISLog 0.91429cm 9.73968cm textbox3 6 true 0.53333cm textbox2 1 true =Sum(Fields!Requests.Value) 2.51428cm c13a6342-b76c-4be0-8d0f-8598eac7fa80 2.5cm true select usernameonly as username , TimePeriod, DateText, DateYYYYMMDD , sum(processingtime) as ProcessingTime, count(*) as Requests from IISLogFilteredWithPeriods where logtime > dateadd(d, -7, getdate()) group by usernameonly, TimePeriod, DateText, DateYYYYMMDD DataSource2 System.String username System.String TimePeriod System.String DateText System.String DateYYYYMMDD System.Int32 ProcessingTime System.Int32 Requests 16.5cm 11in en-US 2.5cm 29.7cm