<
telerik:RadChart
ID
=
"linkchart"
runat
=
"server"
Height
=
"400px"
Skin
=
"Office2007"
Width
=
"925px"
DefaultType
=
"Line"
IntelligentLabelsEnabled
=
"True"
>
<
Appearance
>
<
Border
Color
=
"134, 134, 134"
/>
</
Appearance
>
<
Series
>
<
telerik:ChartSeries
Name
=
"Series 1"
Type
=
"Line"
>
<
Appearance
>
<
FillStyle
FillType
=
"Solid"
MainColor
=
"69, 115, 167"
>
</
FillStyle
>
<
TextAppearance
TextProperties-Color
=
"Black"
>
</
TextAppearance
>
<
Border
Color
=
"69, 115, 167"
/>
</
Appearance
>
</
telerik:ChartSeries
>
</
Series
>
<
Legend
Visible
=
"False"
>
<
Appearance
Dimensions-Margins
=
"15%, 2%, 1px, 1px"
Dimensions-Paddings
=
"2px, 8px, 6px, 3px"
Visible
=
"False"
>
<
ItemTextAppearance
TextProperties-Color
=
"Black"
>
</
ItemTextAppearance
>
<
ItemMarkerAppearance
Figure
=
"Square"
>
</
ItemMarkerAppearance
>
</
Appearance
>
</
Legend
>
<
PlotArea
>
<
XAxis
>
<
Appearance
Color
=
"134, 134, 134"
MajorTick-Color
=
"134, 134, 134"
LabelAppearance-RotationAngle
=
"-90"
>
<
MajorGridLines
Color
=
"134, 134, 134"
Width
=
"0"
/>
<
LabelAppearance
RotationAngle
=
"-90"
>
</
LabelAppearance
>
<
TextAppearance
TextProperties-Color
=
"Black"
Position-AlignedPosition
=
"None"
>
</
TextAppearance
>
</
Appearance
>
<
AxisLabel
>
<
Appearance
Position-AlignedPosition
=
"Bottom"
>
</
Appearance
>
<
TextBlock
>
<
Appearance
TextProperties-Color
=
"Black"
Position-AlignedPosition
=
"Bottom"
>
</
Appearance
>
</
TextBlock
>
</
AxisLabel
>
</
XAxis
>
<
YAxis
>
<
Appearance
Color
=
"134, 134, 134"
MajorTick-Color
=
"134, 134, 134"
MinorTick-Color
=
"134, 134, 134"
>
<
MajorGridLines
Color
=
"134, 134, 134"
/>
<
MinorGridLines
Color
=
"134, 134, 134"
/>
<
TextAppearance
TextProperties-Color
=
"Black"
>
</
TextAppearance
>
</
Appearance
>
<
AxisLabel
>
<
TextBlock
>
<
Appearance
TextProperties-Color
=
"Black"
>
</
Appearance
>
</
TextBlock
>
</
AxisLabel
>
</
YAxis
>
<
Appearance
Dimensions-Margins
=
"25px, 25px, 75px, 75px"
>
<
FillStyle
FillType
=
"Solid"
MainColor
=
""
>
</
FillStyle
>
</
Appearance
>
</
PlotArea
>
<
ChartTitle
Visible
=
"False"
>
<
Appearance
Visible
=
"False"
>
<
FillStyle
MainColor
=
""
>
</
FillStyle
>
</
Appearance
>
<
TextBlock
>
<
Appearance
TextProperties-Color
=
"Black"
TextProperties-Font
=
"Arial, 18px"
>
</
Appearance
>
</
TextBlock
>
</
ChartTitle
>
</
telerik:RadChart
>
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.