Hello ... I built following simple chart binding to a sql datasource (stored procedure / pivot table)
My problem is, that column "year" is displaying on the yaxis (values 2005, 2006 ...) ... if I change the sql statement to
"SELECT 'Y' + CONVERT(VARCHAR(4),YEAR) as Year" the issue is gone.
Thank you...
<
telerik:RadChart
ID
=
"RC_Line1"
runat
=
"server"
DataSourceID
=
"SDS_Chart_Line1"
DefaultType
=
"Line"
Skin
=
"Office2007"
AutoLayout
=
"True"
SeriesPalette
=
"Pal1"
Height
=
"600px"
Width
=
"800px"
IntelligentLabelsEnabled
=
"True"
>
<
CustomPalettes
>
<
telerik:Palette
Name
=
"Pal1"
>
<
Items
>
<
telerik:PaletteItem
MainColor
=
"Yellow"
SecondColor
=
"Black"
></
telerik:PaletteItem
>
<
telerik:PaletteItem
MainColor
=
"Blue"
SecondColor
=
"Black"
></
telerik:PaletteItem
>
<
telerik:PaletteItem
MainColor
=
"Red"
SecondColor
=
"Black"
></
telerik:PaletteItem
>
<
telerik:PaletteItem
MainColor
=
"Orange"
SecondColor
=
"Black"
></
telerik:PaletteItem
>
<
telerik:PaletteItem
MainColor
=
"Green"
SecondColor
=
"Black"
></
telerik:PaletteItem
>
<
telerik:PaletteItem
MainColor
=
"Cyan"
SecondColor
=
"Black"
></
telerik:PaletteItem
>
<
telerik:PaletteItem
MainColor
=
"Magenta"
SecondColor
=
"Black"
></
telerik:PaletteItem
>
<
telerik:PaletteItem
MainColor
=
"Gray"
SecondColor
=
"Black"
></
telerik:PaletteItem
>
<
telerik:PaletteItem
MainColor
=
"FloralWhite"
SecondColor
=
"Black"
></
telerik:PaletteItem
>
<
telerik:PaletteItem
MainColor
=
"Turquoise"
SecondColor
=
"Black"
></
telerik:PaletteItem
>
</
Items
>
</
telerik:Palette
>
</
CustomPalettes
>
<
Appearance
Border-Visible
=
"False"
></
Appearance
>
<
ChartTitle
>
<
Appearance
>
<
FillStyle
MainColor
=
""
></
FillStyle
>
</
Appearance
>
<
TextBlock
Text
=
"Pappas AUT"
>
<
Appearance
TextProperties-Font
=
"Arial, 18px"
TextProperties-Color
=
"Black"
></
Appearance
>
</
TextBlock
>
</
ChartTitle
>
<
Legend
>
<
Appearance
Position-AlignedPosition
=
"Right"
>
<
ItemTextAppearance
TextProperties-Color
=
"Black"
></
ItemTextAppearance
>
<
ItemMarkerAppearance
Figure
=
"Square"
></
ItemMarkerAppearance
>
<
Border
Visible
=
"False"
/>
</
Appearance
>
</
Legend
>
<
PlotArea
>
<
XAxis
DataLabelsColumn
=
"Year"
LayoutMode
=
"Normal"
></
XAxis
>
<
YAxis
><
Appearance
MinorGridLines-Visible
=
"False"
></
Appearance
></
YAxis
>
</
PlotArea
>
</
telerik:RadChart
>
My problem is, that column "year" is displaying on the yaxis (values 2005, 2006 ...) ... if I change the sql statement to
"SELECT 'Y' + CONVERT(VARCHAR(4),YEAR) as Year" the issue is gone.
Thank you...