SSRS 2008 - Range bar chart -The position of the data point is not proper when the data value is zero

Posted on 2012-09-05
Last Modified: 2012-09-12
I have a range bar graph report –SSRS 2008. The position of the data point when the data value is zero should be on y axis. I have tried setting the BarLabelStyle properties but no luck. Please find below the screenshot of the report.
When the data value is zero then the position of the data point should be at zero on y axis but currently the position is away from zero and is positioned at center of the series bar as shown. I am displaying confidence intervals low and high in a black series line and data value as orange dot. The position of the Orange dot is currently at center but it should be at the data value. When user mouse hovers on orange dot I am displaying low, high and values. Is this behavior happening because the data value is small? Any guidance on this issue will be appreciated. Also I am attaching the rdl file for better understanding.
The properties I have used are as below.

Chart Series properties:
Border color=IIF(Avg(Fields!COMT_Age_Adj_Rate.Value)<0,"White","orange")
Border style = None
Border width=IIF(Avg(Fields!COMT_Age_Adj_Rate.Value)<0,"0pt","1pt")
Color =IIF(Avg(Fields!COMT_Age_Adj_Rate.Value)<0,"Black","Orange")
Font Size =IIF(Avg(Fields!COMT_Age_Adj_Rate.Value)<0,"10pt","3pt")
Position = Auto
Label = *
Tooltip=Fields!County.Value & ": " & IIF(Avg(Fields!COMT_Age_Adj_Rate.Value)<0,"*",Avg(Fields!COMT_Age_Adj_Rate.Value)) & " (" & IIF(Avg(Fields!COMT_Age_Adj_Rate_LCL.Value)<0,"*",Avg(Fields!COMT_Age_Adj_Rate_LCL.Value)) & " - " & IIF(Avg(Fields!COMT_Age_Adj_Rate_UCL.Value)<0,"*",Avg(Fields!COMT_Age_Adj_Rate_UCL.Value))& ")"
Custom Attributes
PointWidth =0.5
Question by:comtec100
    LVL 22

    Accepted Solution

    The Range Bar chart type only has two values. The high and low value. Just because the name of your range is COMT_Age_Adj_Rate doesn't mean it displays this value. You could just rename the range and the result would be the same.
    You might be able to get something similar to what you need by using two seperate series in the chart. One series for the high/low value and one to just display the data point.
    Or you could use one of the other range chart types that use more than 2 values.

    Author Comment

    Thanks Nicobo. Your suggestion helped me. I have created One series for the high/low value and one to just display the data point and it worked.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Suggested Solutions

    Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
    How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
    This video discusses moving either the default database or any database to a new volume.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now