Report Chart ALL in X Axis

13 posts, 0 answers
  1. Craig Aussie
    Craig Aussie avatar
    17 posts
    Member since:
    Mar 2006

    Posted 04 Jan Link to this post

    I have a pretty simple bar chart and the first label on the X Axis is ALL. Where does this come from? It is not in the data.

     In the attached screenshot you will also see the bars are not centered above each label, why is this?

     And finally, the bars are very narrow, why is this and how can I make them wider?

  2. Craig Aussie
    Craig Aussie avatar
    17 posts
    Member since:
    Mar 2006

    Posted 04 Jan in reply to Craig Aussie Link to this post

    I worked it out so don't worry.
  3. DevCraft banner
  4. Katia
    Admin
    Katia avatar
    305 posts

    Posted 05 Jan Link to this post

    Hello Craig,

    I am glad to hear that.


    For anyone concerned:

    This result might occur when having an additional series grouping  - Groupings property in the SeriesGroups section of your Graph item. Please check Connecting to Data help article for details how the data is aggregated in a Graph item. Once the grouping is removed, the bars will be centered in their slots.

    If you need to control the width of bars, please see How to: Change the Gap between the Bars help article. In general the steps would be:

    - On the design surface select the target axis.
    In the Misc section set the Scale.SpacingSlotCount property according to your requirements.

    Regards,
    Katia
    Telerik
    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 Feedback Portal and vote to affect the priority of the items
  5. Ali
    Ali avatar
    6 posts
    Member since:
    Oct 2015

    Posted 21 Nov in reply to Craig Aussie Link to this post

    hello

    how did u remove "ALL"

    Thank you

  6. Ali
    Ali avatar
    6 posts
    Member since:
    Oct 2015

    Posted 21 Nov in reply to Katia Link to this post

    hello
    how to remove "ALL"
    Thank you
  7. Katia
    Admin
    Katia avatar
    305 posts

    Posted 21 Nov Link to this post

    Hello Ali,

    The approach is described in my previous post. Test removing the grouping for the Graph.SeriesGroup property. You can also check if the data is organized correctly for the Graph item following Connecting to Data help article.

    If this approach does not help you can attach the problematic report in a support ticket so we can check the settings.


    Regards,
    Katia
    Telerik by Progress
    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 Feedback Portal and vote to affect the priority of the items
  8. Ali
    Ali avatar
    6 posts
    Member since:
    Oct 2015

    Posted 29 Nov in reply to Katia Link to this post

    Hello

    when removing the grouping for the Graph.SeriesGroup property, all the series disappeared and only "ALL"is kept on the XAxis.

    COuld you please help me>?

  9. Katia
    Admin
    Katia avatar
    305 posts

    Posted 29 Nov Link to this post

    Hello Ali,

    It seems that some grouping for the Graph is missing or the data might not be grouped correctly. Note that CategoryGroups always needs to have a grouping expression - check this short video describing the scenario.

    If the issue persists please send us a problematic report together with some test data in a support ticket so we can check the Graph's settings.


    Regards,
    Katia
    Telerik by Progress
    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 Feedback Portal and vote to affect the priority of the items
  10. Ali
    Ali avatar
    6 posts
    Member since:
    Oct 2015

    Posted 29 Nov in reply to Katia Link to this post

    Hello

    Thank you for your reply

    It is true I dont need a categorygroup in my graph, at the same time i want to hide the expression "ALL". Is this possible?

  11. Katia
    Admin
    Katia avatar
    305 posts

    Posted 29 Nov Link to this post

    Hi Ali,

    In general, Category Groups always need to have a grouping expression. If it is missing the Graph will display "ALL" label for the categories.


    Regards,
    Katia
    Telerik by Progress
    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 Feedback Portal and vote to affect the priority of the items
  12. Ali
    Ali avatar
    6 posts
    Member since:
    Oct 2015

    Posted 30 Nov in reply to Katia Link to this post

    Hello

    I added categorygroup but it still has the same problem with the categories stated before the series on the XAxis.

    here is the code:

     // 
                // graph2
                // 
                graphGroup3.Name = "categoryGroup1";
                this.graph2.CategoryGroups.Add(graphGroup3);
                monochromaticPalette1.BaseColor = System.Drawing.Color.DodgerBlue;
                this.graph2.ColorPalette = monochromaticPalette1;
                this.graph2.CoordinateSystems.Add(this.cartesianCoordinateSystem1);
                this.graph2.DataSource = this.facGovDataSource;
                this.graph2.Legend.Style.LineColor = System.Drawing.Color.LightGray;
                this.graph2.Legend.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
                this.graph2.Legend.Style.Visible = false;
                this.graph2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(9.9921220680698752E-05D), Telerik.Reporting.Drawing.Unit.Cm(1.6000007390975952D));
                this.graph2.Name = "graph2";
                this.graph2.NoDataStyle.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
                this.graph2.NoDataStyle.Visible = false;
                this.graph2.PlotAreaStyle.LineColor = System.Drawing.Color.LightGray;
                this.graph2.PlotAreaStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
                this.graph2.PlotAreaStyle.Visible = false;
                this.graph2.Series.Add(this.barSeries2);
                graphGroup6.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.Governerate"));
                graphGroup6.Name = "governerateGroup";
                graphGroup6.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Governerate", Telerik.Reporting.SortDirection.Asc));
                this.graph2.SeriesGroups.Add(graphGroup6);
                this.graph2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(19.311805725097656D), Telerik.Reporting.Drawing.Unit.Cm(7.6999998092651367D));
                this.graph2.Style.BorderColor.Top = System.Drawing.SystemColors.ActiveBorder;
                this.graph2.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
                graphTitle2.Position = Telerik.Reporting.GraphItemPosition.TopCenter;
                graphTitle2.Style.LineColor = System.Drawing.Color.LightGray;
                graphTitle2.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
                graphTitle2.Text = "";
                this.graph2.Titles.Add(graphTitle2);
                // 
                // cartesianCoordinateSystem1
                // 
                this.cartesianCoordinateSystem1.Name = "cartesianCoordinateSystem1";
                this.cartesianCoordinateSystem1.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
                this.cartesianCoordinateSystem1.XAxis = this.graphAxis4;
                this.cartesianCoordinateSystem1.YAxis = this.graphAxis3;
                // 

     

    and i attached a screenshot

  13. Katia
    Admin
    Katia avatar
    305 posts

    Posted 30 Nov Link to this post

    Hi Ali,

    If the data you have does not have categories and you want to show only the series for a single category slot, you can leave the CategoryGroups grouping expression empty and then change the "ALL" label on the XAxis with CategoryGroup.Label property.

    Check the attached report demonstrating this approach (can be opened with Standalone Designer R3 2016).


    Regards,
    Katia
    Telerik by Progress
    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 Feedback Portal and vote to affect the priority of the items
  14. Ali
    Ali avatar
    6 posts
    Member since:
    Oct 2015

    Posted 5 days and 20 hours ago in reply to Katia Link to this post

    Solved!! Thank you very  much

Back to Top
DevCraft banner