This is a migrated thread and some comments may be shown as answers.

Can't Get DefaultLabelValue Working At Runtime

5 Answers 68 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Steve
Top achievements
Rank 1
Steve asked on 29 Jan 2011, 05:42 AM
I appreciate the help in advance!

I have some code here for a chart in my report which resides in the NeedDataSource for the chart.  Everything's working great "except one line" which should change the "stacked bar 100" chart Y labels to percentages (I have four databound series which show fine on the chart otherwise):

 

 

For ThisOne As Integer = 0 To 4

 

 

 

Me.Chart1.Series(ThisOne).Name = Me.ReportParameters("DataTitle" + (ThisOne + 1).ToString).Value

 

 

 

Me.Chart1.Series(ThisOne).Appearance.LabelAppearance.LabelLocation = Charting.Styles.StyleSeriesItemLabel.ItemLabelLocation.Inside

 

 

 

Me.Chart1.Series(ThisOne).Appearance.LabelAppearance.Position.AlignedPosition = Charting.Styles.AlignedPositions.Center

 

 

 

Me.Chart1.Series(ThisOne).Appearance.TextAppearance.TextProperties.Color = Color.Black

 

 

 

Me.Chart1.Series(ThisOne).Appearance.Shadow.Blur = 4

 

 

 

Me.Chart1.Series(ThisOne).Appearance.Shadow.Distance = 2

 

 

 

Me.Chart1.Series(ThisOne).Appearance.Shadow.Position = Charting.Styles.ShadowPosition.BottomRight

 

 

 

Me.Chart1.Series(ThisOne).DefaultLabelValue = "#%"

 

 

 

Next

 


I expected from the documentation and forums that the "DefaultLabelValue" line would change the stacked bar labels to percentages but it does not for me.  I can set the DefaultLabelValue property at design time and all looks dandy, however, that property gets wiped out at the time of the NeedDataSource, hence my feeble attempt here to make things right...

Please point me to the errors of my ways so I can wrap up this chart!

Thanks,
Steve

5 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 02 Feb 2011, 02:14 PM
Hi Steve,

If you set the DataLabelsColumn property in the report designer, please remove it.  This interferes with DefaultLabelValue which needs the value from the DataYColumn (through the #Y token) as a numeric value, so that the format is applied. DataLabelsColumn is intended for cases, where one would need a string label, taken from a completely different column.

Best wishes,
Steve
the Telerik team
Get started with Telerik Reporting with numerous videos and detailed documentation.
0
Steve
Top achievements
Rank 1
answered on 02 Feb 2011, 03:09 PM
Thank you!   That worked like a champ!

Steve
0
Rose
Top achievements
Rank 1
answered on 26 Apr 2011, 07:05 PM
Unable to change LabelLocation to inside
  
I have numerous stacked bar charts that I need to make readable.  I have tried positioning the label inside as well out setting to auto.  The problem is that when a number is very small it isn't very readable.  I have a live date next week and need a solution.    
  
   Telerik.Reporting.Processing.Chart chart = sender as Telerik.Reporting.Processing.Chart;
  
            DataTable table = new DataTable();
            table.Columns.Add("PRM", typeof(string));
            table.Columns.Add("Argatroban", typeof(string));
            table.Columns.Add("Arixtra", typeof(string));
            table.Columns.Add("Arranon", typeof(string));
            table.Columns.Add("Arzerra", typeof(string));
            table.Columns.Add("Benlysta", typeof(string));
            table.Columns.Add("Bexxar", typeof(string));
            table.Columns.Add("Hycamtin ora", typeof(string));
            table.Columns.Add("Promacta", typeof(string));
            table.Columns.Add("Tykerb", typeof(string));
            table.Columns.Add("Votrient", typeof(string));
            table.Columns.Add("General", typeof(string));
            table.Columns.Add("Other", typeof(string));
            table.Rows.Add(new object[] { "Test 1", 22, 5, 303, 165, 77, 32, 55, 99, 233, 111, 48, 18 });
            table.Rows.Add(new object[] { "Test 2", 202, 50, 33, 6, 177, 2, 15, 44, 233, 11, 4, 108 });
            
            chart.DataSource = table;
  
            chart1.ChartTitle.TextBlock.Text = "TEST PRM Activity for: " + ReportSessionData.UserName;
  
            Palette palette = new Palette("MyPalette");
            palette.Items.Add(new PaletteItem(Color.LightSkyBlue, Color.LightSkyBlue));
            palette.Items.Add(new PaletteItem(Color.CadetBlue, Color.CadetBlue));
            palette.Items.Add(new PaletteItem(Color.Blue, Color.Blue));
            palette.Items.Add(new PaletteItem(Color.LawnGreen, Color.LawnGreen));
            palette.Items.Add(new PaletteItem(Color.LightCoral, Color.LightCoral));
            palette.Items.Add(new PaletteItem(Color.MediumVioletRed, Color.MediumVioletRed));
            palette.Items.Add(new PaletteItem(Color.MistyRose, Color.MistyRose));
            palette.Items.Add(new PaletteItem(Color.LimeGreen, Color.LimeGreen));
            palette.Items.Add(new PaletteItem(Color.MediumSpringGreen, Color.MediumSpringGreen));
            palette.Items.Add(new PaletteItem(Color.Green, Color.Green));
            palette.Items.Add(new PaletteItem(Color.DarkGreen, Color.DarkGreen));
            palette.Items.Add(new PaletteItem(Color.ForestGreen, Color.ForestGreen));
            chart1.CustomPalettes.Add(palette);
            chart1.SeriesPalette = "MyPalette";
  
            chart1.Series[0].PlotArea.XAxis.DataLabelsColumn = "PRM";
            chart1.Series[0].Appearance.LabelAppearance.LabelLocation = Telerik.Reporting.Charting.Styles.StyleSeriesItemLabel.ItemLabelLocation.Inside;
0
Steve
Telerik team
answered on 29 Apr 2011, 05:11 PM
Hi Rose,

You've bound the chart directly by using the DataSource property, however this way chart series and items are created automatically and you do not have control over them. The proper way to do this would be to bind the chart through the designer by using our Data Source Components. This way you would create the series from the series collection, specify the DataYColumn/DataLabelsColumn for the series and of course control the LabelAppearance properties as well. You can change the position of the item label from Series --> Appearance --> LabelAppearance --> LabelLocation="Inside" and Series --> Appearance --> LabelAppearance --> Position --> AlignedPosition="Center".

Regards,
Steve
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Rose
Top achievements
Rank 1
answered on 29 Apr 2011, 09:38 PM
Thanks so much for replying.  Unfortunately that is not an option.  This is what I've come up with and the client is pleased.  Since this is a global issue  how would you suggest  coding in the future.  All in code behind page.  I am really needing to become an expert as we have a lot of new projects needing report.  Long label are also a big issue!  Any help would be appreciated that will make these reports more readable.
private void chart1_NeedDataSource(object sender, EventArgs e)
       {
           InputVariables iv = new InputVariables();
           iv.RptStart = ReportSessionData.StartDate;
           iv.RptEnd = ReportSessionData.EndDate;
           iv.ProductName = ReportSessionData.ProductName;
           iv.PRMID = ReportSessionData.PRMID;
           iv.UserID = ReportSessionData.UserID;
           iv.UserName = ReportSessionData.UserName;
           iv.Data.Open();
           iv.SetVariables();
           iv.SetMeasures();
           iv.InitializeMeasures();
           iv.ExecuteMeasures(iv.MeasureList[0]);
           DataTable dt = iv.MeasureList[0].OutputTable;
           iv.Data.Close();
           Telerik.Reporting.Processing.Chart chart = (Telerik.Reporting.Processing.Chart)sender;
           chart1.DataGroupColumn = "Type";
           chart1.PlotArea.XAxis.DataLabelsColumn = "PRM";
           //   chart1.PlotArea.YAxis.AxisLabel.TextBlock.Text = "Count of products by PRM";
           chart1.PlotArea.YAxis.AxisLabel.Visible = true;
           chart1.Series.Clear();
           foreach (DataRow dr in dt.Rows)
           {
               ChartSeries cs = null;
               if (chart1.Series.GetByName(dr["Type"].ToString()) == null)
               {
                   cs = new ChartSeries();
                   cs.Type = ChartSeriesType.StackedBar;
                   cs.Name = dr["Type"].ToString();
                   cs.DataYColumn = "Count";
                   cs.Appearance.LabelAppearance.Visible = false;
                   chart1.Series.Add(cs);
               }
               else
                   cs = chart1.Series.GetByName(dr["Type"].ToString());
               ChartSeriesItem csi = new ChartSeriesItem();
               csi.Label.TextBlock.Text = "";
               csi.Label.Visible = false;
               csi.Label.Appearance.Visible = false;
               cs.AddItem(csi);
           }
           dt.AcceptChanges();
           chart.DataSource = dt;
           for (int i = 0; i < chart1.Series.Count; i++)
               for (int j = 0; j < chart1.Series[i].Items.Count; j++)
               {
                   chart1.Series[i].Items[j].Label.Appearance.Visible = false;
                   chart1.Series[i].Items[j].Label.Visible = false;
                   chart1.Series[i].Items[j].Label.TextBlock.Text = "";
                   chart1.Series[i].Appearance.LabelAppearance.Visible = false;
                   chart1.Series[i].Appearance.ShowLabels = false;
               }
           chart1.ChartTitle.TextBlock.Text = "PRM Activity for: " + ReportSessionData.UserName;
           Palette palette = new Palette("MyPalette");
           palette.Items.Add(new PaletteItem(Color.LightSkyBlue, Color.LightSkyBlue));
           palette.Items.Add(new PaletteItem(Color.CadetBlue, Color.CadetBlue));
           palette.Items.Add(new PaletteItem(Color.Blue, Color.Blue));
           palette.Items.Add(new PaletteItem(Color.LawnGreen, Color.LawnGreen));
           palette.Items.Add(new PaletteItem(Color.LightCoral, Color.LightCoral));
           palette.Items.Add(new PaletteItem(Color.MediumVioletRed, Color.MediumVioletRed));
           palette.Items.Add(new PaletteItem(Color.MistyRose, Color.MistyRose));
           palette.Items.Add(new PaletteItem(Color.LimeGreen, Color.LimeGreen));
           palette.Items.Add(new PaletteItem(Color.MediumSpringGreen, Color.MediumSpringGreen));
           palette.Items.Add(new PaletteItem(Color.Green, Color.Green));
           palette.Items.Add(new PaletteItem(Color.DarkGreen, Color.DarkGreen));
           palette.Items.Add(new PaletteItem(Color.ForestGreen, Color.ForestGreen));
           chart1.CustomPalettes.Add(palette);
           chart1.SeriesPalette = "MyPalette";
 
Tags
General Discussions
Asked by
Steve
Top achievements
Rank 1
Answers by
Steve
Telerik team
Steve
Top achievements
Rank 1
Rose
Top achievements
Rank 1
Share this question
or