or
<system.webServer>
....<handlers>
....
<add name="Telerik.ReportViewer.axd_*" path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" preCondition="integratedMode,runtimeVersionv2.0" />
</handlers>
<httpHandlers> <remove path="*.asmx" verb="*" /> <add path="*.asmx" verb="*" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false" /> <add path="*_AppService.axd" verb="*" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false" /> <add path="ScriptResource.axd" verb="GET,HEAD" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false" /> <add path="ChartImage.axd" verb="*" type="Telerik.Web.UI.ChartHttpHandler" validate="false" /> <add path="Telerik.Web.UI.SpellCheckHandler.axd" verb="*" type="Telerik.Web.UI.SpellCheckHandler" validate="false" /> <add path="Telerik.Web.UI.DialogHandler.aspx" verb="*" type="Telerik.Web.UI.DialogHandler" validate="false" /> <add path="Telerik.RadUploadProgressHandler.ashx" verb="*" type="Telerik.Web.UI.RadUploadProgressHandler" validate="false" /> <add path="Telerik.Web.UI.WebResource.axd" verb="*" type="Telerik.Web.UI.WebResource" validate="false" /> <add path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=5.3.11.1222, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" validate="true" preCondition="integratedMode,runtimeVersionv2.0"/> </httpHandlers> <httpModules> <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" /> <!--<add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule"/> <add name="RadCompression" type="Telerik.Web.UI.RadCompression"/>--> </httpModules><%@ Register assembly="Telerik.ReportViewer.WebForms, Version=5.3.11.1222, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" namespace="Telerik.ReportViewer.WebForms" tagprefix="telerik" %> <asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">Telerik.Reporting.
SubReport grandChildSubReport = this.subReport1.Items.Find("subReport2", true)[0] as Telerik.Reporting.SubReport;
Please help
Thanks
SELECT w.Firstname, w.Lastname, wf.Login, wf.Logout, DATEDIFF(hour, wf.Login, wf.Logout) AS HoursFROM Workers AS w INNER JOIN Workflow AS wf ON wf.LoggedInWorkerid = w.IDWHERE (wf.Login >= @dtstrtDate) AND (wf.Logout <= @dtendDate)DECLARE @dtstrtDate AS DateTimeSET @dtstrtDate = '02/13/2012'DECLARE @dtendDate AS DateTimeSET @dtendDate = '02/17/2012'SELECT w.Firstname, w.Lastname, SUM(DATEDIFF(hour, wf.Login, wf.Logout)) AS HoursFROM Workers AS w JOIN Workflow AS wf ON wf.LoggedInWorkerid = w.ID WHERE wf.Login >= @dtstrtDate AND wf.Logout <= @dtendDate GROUP BY w.Lastname, w.FirstName