HTML
<P><%@ Page Title="" Language="C#" MasterPageFile="~/Modules/Reports/ReportMasterPage.master"<BR> AutoEventWireup="true" CodeBehind="AnalystBreakdownList.aspx.cs" Inherits="CreativeAffairsWebApp.Modules.Reports.AnalystBreakdownList" %></P> <P><%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"<BR> Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %><BR><asp:Content ID="Content1" ContentPlaceHolderID="ReportHeadContent" runat="server"><BR></asp:Content><BR><asp:Content ID="Content2" ContentPlaceHolderID="ReportMainContent" runat="server"><BR> <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" LoadingPanelID="RadAjaxLoadingPanel1" Width="100%"><BR> <table style="width: 100%;" class="form"><BR> <tr><BR> <td><BR> <table border="0" cellpadding="0" cellspacing="0"><BR> <tr><BR> <td><BR> <asp:Label ID="Label1" runat="server" Text="As Of Date:" CssClass="formLabel"></asp:Label><BR> <telerik:RadDatePicker ID="txtReportDate" runat="server"><BR> <Calendar Skin="WebBlue" UseColumnHeadersAsSelectors="False" runat="server" UseRowHeadersAsSelectors="False"<BR> ViewSelectorText="x"><BR> </Calendar><BR> <DateInput runat="server" DateFormat="M/d/yyyy" DisplayDateFormat="M/d/yyyy"><BR> </DateInput><BR> <DatePopupButton HoverImageUrl="" ImageUrl="" /><BR> </telerik:RadDatePicker><BR> </td><BR> <td><BR> <BR> <telerik:RadButton ID="RadButton1" runat="server" Text="Run Report" OnClick="Button1_Click"><BR> </telerik:RadButton><BR> </td><BR> </tr><BR> </table><BR> <br /><BR> </td><BR> </tr><BR> </table><BR> <table width="100%"><BR> <tr><BR> <td class="style1"><BR> <asp:Panel ID="reportPanel" runat="server" Visible="false"><BR> <rsweb:ReportViewer ID="ReportViewer1" runat="server" Width="100%" Height="600px"<BR> PageCountMode="Actual" ShowParameterPrompts="False" BackColor="White"><BR> </rsweb:ReportViewer><BR> </asp:Panel><BR> <BR> <BR> </td><BR> </tr><BR> </table><BR> </telerik:RadAjaxPanel><BR> <BR> <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Default"><BR> </telerik:RadAjaxLoadingPanel><BR> <BR></asp:Content></P>
<P>protected void Button1_Click(object sender, EventArgs e)<BR> {<BR> ReportViewer1.ProcessingMode = ProcessingMode.Remote;<BR> <BR> ReportViewer1.ServerReport.ReportServerUrl = new Uri(ReportUtils.GetReportServerURL());<BR> ReportViewer1.ServerReport.ReportPath = ReportUtils.GetReportPath("AnalystBreakdownList");</P> <P> ReportParameterCollection par = new ReportParameterCollection();<BR> ReportParameter username = new ReportParameter("UserName", Utils.SessionValues.GetLoggedUserName());<BR> par.Add(username);</P> <P> ReportParameter asOfDate = new ReportParameter("AsOfDate", txtReportDate.SelectedDate.ToString());<BR> par.Add(asOfDate);</P> <P> ReportViewer1.ServerReport.SetParameters(par);</P> <P> reportPanel.Visible = true;<BR> //ReportViewer1.Visible = true;</P> <P> ReportViewer1.ServerReport.Refresh();<BR> }</P><telerik:GridNumericColumn DataField="Feb" DataType="System.Int32" HeaderText="Feb" DecimalDigits="0" EditFormColumnIndex="0" SortExpression="Feb" UniqueName="Feb" FilterControlWidth="50px" ><HeaderStyle Width="80px" /></telerik:GridNumericColumn> <telerik:RadChart ID="RadChart1" runat="server" Height="550px" SeriesOrientation="Horizontal" Width="900px" Skin="DeepBlue" IntelligentLabelsEnabled="True"> <Appearance> <FillStyle FillType="ComplexGradient"> <FillSettings> <ComplexGradient> <telerik:GradientElement Color="26, 120, 179" /> <telerik:GradientElement Color="35, 189, 254" Position="0.5" /> <telerik:GradientElement Color="26, 120, 179" Position="1" /> </ComplexGradient> </FillSettings> </FillStyle> <Border Color="0, 66, 110" Width="5" /> </Appearance> <Legend> <Appearance Dimensions-Margins="1px, 2%, 12%, 1px" Position-AlignedPosition="BottomLeft" Position-Auto="False" Position-X="5" Position-Y="500"> <ItemAppearance> <FillStyle FillType="Solid" MainColor="Transparent"> </FillStyle> </ItemAppearance> <ItemTextAppearance TextProperties-Color="White"> </ItemTextAppearance> <FillStyle GammaCorrection="False" MainColor="Transparent"> </FillStyle> <Border Color="76, 255, 255, 255" /> </Appearance> <TextBlock Visible="True"> <Appearance Position-AlignedPosition="BottomLeft" TextProperties-Color="LightSkyBlue"> <FillStyle MainColor="Transparent" FillType="Solid"> </FillStyle> </Appearance> </TextBlock> </Legend> <PlotArea> <EmptySeriesMessage Visible="True"> <Appearance Visible="True"> </Appearance> <TextBlock Visible="true" Text="No Therapeutic Areas Discussed"> </TextBlock> </EmptySeriesMessage> <XAxis> <Appearance Color="98, 183, 226" MajorTick-Color="98, 183, 226"> <MajorGridLines Color="98, 183, 226" Width="0" /> <TextAppearance TextProperties-Color="White"> </TextAppearance> </Appearance> <AxisLabel> <Appearance Position-Auto="false" Position-X="750" Position-Y="605" Dimensions-Paddings="1px, 1px, 10%, 1px" RotationAngle="270"> </Appearance> <TextBlock Text="Percentage of Surveys" Visible="true"> <Appearance TextProperties-Color="LightSkyBlue"> </Appearance> </TextBlock> </AxisLabel> </XAxis> <YAxis AutoScale="False" MaxItemsCount="10" MaxValue="100" MinValue="0" Step="10" Visible="False"> <Appearance Color="98, 183, 226" MajorTick-Color="98, 183, 226" MinorTick-Color="98, 183, 226"> <MajorGridLines Color="120, 209, 248" /> <MinorGridLines Color="120, 209, 248" Width="0" /> <LabelAppearance Dimensions-AutoSize="False" Dimensions-Height="0px" Position-AlignedPosition="Right" Dimensions-Width="0px"> </LabelAppearance> <TextAppearance TextProperties-Color="White"> </TextAppearance> </Appearance> <AxisLabel Visible="True"> <Appearance Visible="True" RotationAngle="0"> </Appearance> <TextBlock> <Appearance TextProperties-Color="LightSkyBlue" Dimensions-AutoSize="False" Dimensions-Height="16px" Dimensions-Width="160px" AutoTextWrap="False"> </Appearance> </TextBlock> </AxisLabel> <Items> <telerik:ChartAxisItem> </telerik:ChartAxisItem> <telerik:ChartAxisItem Value="10"> </telerik:ChartAxisItem> <telerik:ChartAxisItem Value="20"> </telerik:ChartAxisItem> <telerik:ChartAxisItem Value="30"> </telerik:ChartAxisItem> <telerik:ChartAxisItem Value="40"> </telerik:ChartAxisItem> <telerik:ChartAxisItem Value="50"> </telerik:ChartAxisItem> <telerik:ChartAxisItem Value="60"> </telerik:ChartAxisItem> <telerik:ChartAxisItem Value="70"> </telerik:ChartAxisItem> <telerik:ChartAxisItem Value="80"> </telerik:ChartAxisItem> <telerik:ChartAxisItem Value="90"> </telerik:ChartAxisItem> <telerik:ChartAxisItem Value="100"> </telerik:ChartAxisItem> </Items> </YAxis><YAxis2><AxisLabel><Appearance RotationAngle="0"></Appearance></AxisLabel></YAxis2> <Appearance Dimensions-Margins="19%, 90px, 12%, 25%" Corners="Rectangle, Rectangle, Rectangle, Rectangle, 5" Position-Auto="False" Position-X="225" Position-Y="104.5"> <FillStyle MainColor="50, 255, 255, 255" SecondColor="Transparent"> </FillStyle> <Border Color="97, 180, 223" /> </Appearance> </PlotArea> <ChartTitle> <Appearance Dimensions-Margins="4%, 10px, 14px, 6%"> <FillStyle MainColor=""> </FillStyle> </Appearance> <TextBlock Text=""> <Appearance TextProperties-Color="White" TextProperties-Font="Verdana, 14pt"> </Appearance> </TextBlock> </ChartTitle> </telerik:RadChart>string strNValue = Convert.ToString(prmNValue.Value);SqlDataReader dr = cmd.ExecuteReader();RadChart1.PlotArea.XAxis.DataLabelsColumn = "TherapArea";RadChart1.DataSource = dr;RadChart1.DataBind();RadChart1.Visible = true;RadChart1.PlotArea.YAxis.AxisLabel.Visible = true;RadChart1.PlotArea.XAxis.AxisLabel.Visible = true;RadChart1.PlotArea.YAxis.AxisLabel.TextBlock.Text = "Percentage of Surveys";string strLegend = strManufacturer + " (n=" + strNValue + ")";RadChart1.Legend.TextBlock.Text = strLegend;RadChart1.Series[0].DefaultLabelValue = "#Y%";dr.Close();_objXConn.ConnectionString = String.Format( _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1""", _fullFilePath)
Exception:
System.Data.OleDb.OleDbException: External table is not in the expected format.
There is no issue with the code when i try to open some other excel files with that connection.
Why is this happening? Can you help me?
protected void ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == RadGrid.InitInsertCommandName)
{
(this.Page.FindControl("txtOpcode") as RadTextBox).Visible = false;
//(RadGrid1.MasterTableView.FindControl("txtOpcode") as RadTextBox).Visible = false;
}
Error: Sys.WebForms.PageRequestManagerServerErrorException: Object reference not set to an instance of an object.