0in ContentPlaceHolder 0.875in 1in 6.5in 0.375in 1 Text Page Title true 0.375in =iif(Globals!PageNumber = 1, "", "Remote control benefit") 6.5in 0in ContentPlaceHolder 1.375in 1in 6.5in 0.375in 1 Text Report Title true 0.375in Remote control benefit 6.5in ContentPlaceHolder 1.75in 1in 6.5in 0.375in 2 Text Report Description true 0.375in Estimated savings for using LANDesk to perform remote control 6.5in ContentPlaceHolder 2.75in 1in 6.5in 15.98083cm 4 Text Report Content RemoteControl
0.25in true =Fields!StartTime.Value true =Fields!EndTime.Value true =Fields!ViewingComputer.Value true =Fields!ManagedComputer.Value true =Fields!UserName.Value
0.25in true true true true true
1.229167in 1.302083in 1.302083in 1.302083in 1.302083in 1.291668in
true 0.25in 4 =Month(Fields!StartTime.Value).ToString()+"-"+Year(Fields!StartTime.Value).ToString() true =MonthName(Month(Fields!StartTime.Value)).ToString() +" " + Year(Fields!StartTime.Value).ToString() true ="Total savings: "&Parameters!Saving.Value*CountRows("GroupDate")&" "&Parameters!Currency.Value 0.25in true Start time true End time true Viewing Computer true Managed Computer true User
0.2291667in true true true true true
=Month(Fields!StartTime.Value).ToString()+Year(Fields!StartTime.Value).ToString() 12.85875cm6.5in2
=Month(Fields!StartTime.Value).ToString()+"-"+Year(Fields!StartTime.Value).ToString() true <Caption>Remote Control</Caption> <Style> <Color>Gray</Color> <FontSize>12pt</FontSize> <FontWeight>700</FontWeight> </Style> true =Month(Fields!StartTime.Value).ToString()+Year(Fields!StartTime.Value).ToString() =Month(Fields!StartTime.Value).ToString()+"-"+Year(Fields!StartTime.Value).ToString() =Parameters!Saving.Value*CountRows("GroupDate") true =Parameters!Saving.Value*CountRows("GroupDate") RemoteControl 5.125in BottomCenter Light Plain true 5 Orthographic 5 Real <Caption>=String.Format("Cost saving: {0}\nFrom {1} to {2}",Parameters!Saving.Value*CountRows("GroupDate")&" "&Parameters!Currency.Value.ToString(),Parameters!StartDate.Value.ToShortDateString,Parameters!EndDate.Value.ToShortDateString)</Caption> <Style> <Color>Brown</Color> <FontSize>12pt</FontSize> <FontWeight>700</FontWeight> <TextAlign>Center</TextAlign> </Style> Column <Caption>=Parameters!Currency.Value</Caption> <Style> <Color>Brown</Color> <FontSize>12pt</FontSize> <FontWeight>700</FontWeight> </Style> 6.5in 0in DateTime Start date =Today.AddDays(-10) DateTime End date =Today Integer Saving 0 String Currency USD StartTime EndTime ViewingComputer ManagedComputer UserName select distinct sub.StartTime, sub.EndTime, sub.ViewingComputer, sub.ManagedComputer, sub.UserName from (select r.EventTime as StartTime, MIN(s.EndTime) as EndTime, r.ViewingComputer, r.ManagedComputer, r.UserName from RCLog r join (select EventTime as EndTime, ManagedComputer from RCLog where RCAction_Idn = 2) s on s.ManagedComputer = r.ManagedComputer and s.EndTime > r.EventTime where r.rcaction_idn = 1 group by r.EventTime, r.ViewingComputer, r.ManagedComputer, r.UserName) sub, ROI where -- sub.ViewingComputer in(?) -- and sub.ManagedComputer in (?) --and ROI_Idn = 1 and (sub.StartTime >=@StartDate AND sub.StartTime <= (@EndDate + 1)) LDMS =Parameters!ScopeDevice.Value =Parameters!ScopeDevice.Value =Parameters!StartDate.Value =Parameters!EndDate.Value label Select distinct N'USD' as label from computer union Select distinct N'RMB' as label from computer LDMS DisplayName select c.DisplayName from Computer c left outer join ScopeComputer sc on sc.Computer_Idn=c.Computer_Idn where 1=1 and c.DisplayName is not null LDMS MasterReport C:\USLetterPortrait.rdlx-master