[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

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
2
Medium Priority
?
2,621 Views
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:
High=IIF(Avg(Fields!COMT_Age_Adj_Rate_UCL.Value)<0,0,Avg(Fields!COMT_Age_Adj_Rate_UCL.Value))
Low=IIF(Avg(Fields!COMT_Age_Adj_Rate_LCL.Value)<0,0,Avg(Fields!COMT_Age_Adj_Rate_LCL.Value))
BGColor=IIF(Avg(Fields!COMT_Age_Adj_Rate.Value)<0,"White","Orange")
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
BarLabelStyle=Center
EmptyPointValue=Average
COMortGrpRegionAgeAdjRate.rdl
SampleData.png
RangeBarDataPointPosition.docx
RangeBarDataPointPosition-Actual.png
RangeBarDataPointPosition-Expect.png
ChartSeriesProperties.png
0
Comment
Question by:comtec100
2 Comments
 
LVL 22

Accepted Solution

by:
Nico Bontenbal earned 750 total points
ID: 38382140
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.
0
 

Author Comment

by:comtec100
ID: 38392558
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.
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

612 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