none
Polar Charting with Reporting Services RRS feed

  • Question

  • Does anyone know if you can do polar charting with Reporting Services?  I have a need to report the polar coordinates of an element and show the polar chart of the data elements.  If I can't do polar charting with Reporting Services, does anyone know of a third party product that I can utilize?

     

    Thanks

    KM

    Tuesday, September 11, 2007 2:37 PM

Answers

  • I have an explanation for you.   Polar charts, which is the first chart type in the "polar" header in the chart type picker, require a value/scalar axis.  This means that by default your "X" values need to be between 0 and 360 (representing the number of degrees).  Radar charts (which are the second option in the chart type picker), are based on a category axis and for each record in your dataset it will create a an indexed entry along the x-axis for that record.  

    I'm guessing that when you choose the Polar chart, your data is categorical in nature, so since you are not specifying the x values as 0-360, the chart is placing them at angles 1,2,3,4...etc. based on the number of rows you have.  So that is why you see all of the labels bunched up on each other and it looks like it's not plotting your data. 

    -Sean
    Program Manager, SQL Server Reporting Services
    Thursday, February 12, 2009 6:48 PM

All replies

  • Dundas Chart controls allow polar charting (www.Dundas.com)

     

    BobP

    Tuesday, September 11, 2007 3:33 PM
  • Ok for Dundas, but If we want to use the Polar Chart with Reporting Designer or Report Builder 2.0 ?

    fix
    Thursday, February 12, 2009 8:46 AM
  • Hello,

    In SSRS 2008 you can do Polar Cahrting. But SSRS 2005 does not have this feature.



    Shilpa (http://www.ggktech.com)
    Thursday, February 12, 2009 12:00 PM
  • yes I know.
    That's a little strange.
    There are three Polar Chart. I cannot see values with the first. But the two others work fine.

    Thanks you,

    fix
    Thursday, February 12, 2009 2:59 PM
  • I have an explanation for you.   Polar charts, which is the first chart type in the "polar" header in the chart type picker, require a value/scalar axis.  This means that by default your "X" values need to be between 0 and 360 (representing the number of degrees).  Radar charts (which are the second option in the chart type picker), are based on a category axis and for each record in your dataset it will create a an indexed entry along the x-axis for that record.  

    I'm guessing that when you choose the Polar chart, your data is categorical in nature, so since you are not specifying the x values as 0-360, the chart is placing them at angles 1,2,3,4...etc. based on the number of rows you have.  So that is why you see all of the labels bunched up on each other and it looks like it's not plotting your data. 

    -Sean
    Program Manager, SQL Server Reporting Services
    Thursday, February 12, 2009 6:48 PM
  • thanks you Sean for your explananation.


    fix
    Friday, February 13, 2009 7:08 AM
  • HI all,

    I'm getting pretty desperate with this polar chart. I have the data working and the angles too so I can see everything but I'm having trouble with the Category labels. I cannot make this change the labels and I always get the default angles displayed as the category label.

    I basically have everything I want but I need to make the category label pick up from a field in my data source

    The reality is I wanted a Radar chart instead but not one with all the area filled in, I just wanted a basic one like in Excel but Dundas for SSRS only has Radar chart with the area filled for the values. when you have multiple series, the data points  for one series can be hidden behind others which is not of much use in my situation.

    Is it possible to change the Polar chart category label. when I put an expression in the category label, nothing changes so I might not be doing it properly, although when I turn of cetegory labels, the default angle labels disappear. i can only assume that it IS category labels I'm trying to modify and not something else.

    Can anyone help?

    Annabel.
    Friday, February 20, 2009 10:20 PM
  • HI all,

    OK I have solved my problem and I feel a little silly. After working for hours on end this past week on a variety of things I was obviously brain dumb and didn't have my moment of clarity until 10 minutes ago.


    so here's what I did.

    1. Went back to basic radar chart
    2. for ALL my data series I set the fill to solid and coloue = 'No colour'
    3. Set border type (1st series solid line 2pt, 2nd series dashed line 2pt and 3rd series dash-dot-dash line 2pt)

    And now it all works just fine. I only wish Dundas had a Polygon type since it would be nice to link the category label through to the centre with one of those feint lines......like a true spider web.

    anyhow this is good enough right now

    Annabel
    Friday, February 20, 2009 11:31 PM
  • Hi,

     

    I need something similar.

    I tried what you mentioned AnnabelP, but it doesn't seem to work for me. I dint understand the Step 3 correctly. Can you explain please?

    Thanks

    Monday, July 11, 2011 3:32 PM