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| ASHOK ENTERPRISE | ASHOK ENTERPRISE | |||||
| DATE : | 12/1/2011 | DATE : | 12/1/2011 | |||
| ANAN BUILDERS | ANAN BUILDERS | |||||
| PAYMENT IS DUE AS PER UNDERMENTIONED | PAYMENT IS DUE AS PER UNDERMENTIONED | |||||
| BILLS, SO PLEASE MAKE THE PAYMENT SOON. | BILLS, SO PLEASE MAKE THE PAYMENT SOON. | |||||
| BILL NO. | DATE | AMOUNT Rs. | BILL NO. | DATE | AMOUNT Rs. | |
| 150 | 6/30/2011 | 5000 | 150 | 6/30/2011 | 5000 | |
| 175 | 7/31/2011 | 5500 | 175 | 7/31/2011 | 5500 | |
| 200 | 8/31/2011 | 5500 | 200 | 8/31/2011 | 5500 | |
| 225 | 9/30/2011 | 5000 | 225 | 9/30/2011 | 5000 | |
| 250 | 10/31/2011 | 5500 | 250 | 10/31/2011 | 5500 | |
| 300 | 11/30/2011 | 5000 | 300 | 11/30/2011 | 5000 | |
| TOTAL RS. | 31500 | TOTAL RS. | 31500 | |||
If HttpContext.Current.Session("DynamicReportDatas") IsNot Nothing Then Dim datas As DataTable = HttpContext.Current.Session("DynamicReportDatas") Me.Table1.DataSource = datas Dim textboxGroup As Telerik.Reporting.HtmlTextBox Dim textBoxTable As Telerik.Reporting.HtmlTextBox Table1.ColumnGroups.Clear() Table1.Body.Columns.Clear() Table1.Body.Rows.Clear() Dim ColCount As Integer = datas.Columns.Count For i As Integer = 0 To ColCount - 1 Dim tableGroupColumn As New Telerik.Reporting.TableGroup() Table1.ColumnGroups.Add(tableGroupColumn) 'table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Unit.Inch(1))); textboxGroup = New Telerik.Reporting.HtmlTextBox() 'textboxGroup.Style.BorderColor.[Default] = Color.Black 'textboxGroup.Style.BorderStyle.[Default] = BorderType.Solid textboxGroup.Value = datas.Columns(i).ColumnName textboxGroup.Size = New SizeU(Unit.Inch(1.4), Unit.Inch(0.2)) textboxGroup.Style.BackgroundColor = Color.FromName("#79A7E3") textboxGroup.Style.Font.Bold = True textboxGroup.Style.Font.Size = New Unit(10) textboxGroup.Style.VerticalAlign = VerticalAlign.Middle textboxGroup.Style.TextAlign = HorizontalAlign.Left tableGroupColumn.ReportItem = textboxGroup textBoxTable = New Telerik.Reporting.HtmlTextBox() 'textBoxTable.Style.BorderColor.Default = Color.Black; 'textBoxTable.Style.BorderStyle.Default = BorderType.Solid; textBoxTable.Value = "=Fields.[" + datas.Columns(i).ColumnName & "]" textBoxTable.Size = New SizeU(Unit.Inch(1.4), Unit.Inch(0.3)) textBoxTable.Style.VerticalAlign = VerticalAlign.Middle textBoxTable.Style.TextAlign = HorizontalAlign.Left Table1.Body.SetCellContent(0, i, textBoxTable) Table1.Items.AddRange(New ReportItemBase() {textBoxTable, textboxGroup}) Next End If