?
Solved

SSRS 2008 - Bar  width not consistent in bar graphs

Posted on 2012-08-16
5
Medium Priority
?
2,329 Views
Last Modified: 2012-08-27
Hi,

I have a Column bar graph report (ssrs 2008). Report parameters are start year,End year,Gender . When start year and end year are same the width of the bar is more when compared with bars when start and end years are different. I have Year on X axis and Number on Y axis.
Point width property I have set is PointWidth=0.2.

Attached are the screenshots of the reports for 2 scenarios.
Scenario 1- Start and End year same
scenario 2 - Start and End year different.
I want to show same width of the bar irrespective of year selection

One more case more scenario.
I have range chart graph and set a bar line  PointWidth=0.05. Series lines width is not consistent as shown in the attached figure.
Any help will be appreciated.
Thanks in advance
GraphReport-ThinThickLines-Issue.png
GraphReportPointWidthProperty.png
BarGraph-StartEndYearSame.png
BarGraph-StartEndYearDifferent.png
0
Comment
Question by:comtec100
  • 4
5 Comments
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 38303817
Try setting PointWidth to 1 and PixelPointWidth to 10 (or some other value).
http://msdn.microsoft.com/en-us/library/dd456636.aspx
0
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 38303830
About the line thickness. When you set the zoom level to 200% are the lines still different. And when you open the report in the browser, do you have the problem there also.
Also I see a warning message in your GraphReport-ThinThickLines-Issue.png screenshot. Maybe try to fix that warning and see if that helps.
If that doesn't solve it can you upload the report so I can try to duplicate your problem.
0
 

Author Comment

by:comtec100
ID: 38305241
Hi,
First issue got fixed. I have set  PointWidth to 1 and PixelPointWidth to 10. Now when I run the report for start and end year is same the width remains constant. Width remains constant when start and end year are different.

For second issue I am attaching the report files. I have set PixelPointwidth =1 and pointwidth=0.03. The lines look almost consistent. When you closely observe  some lines are still thick and thin.Could you please help me ?
COMortGrpStateAgeAdjRate.rdl
COMortGrpRegionAgeAdjRate.rdl
0
 
LVL 22

Accepted Solution

by:
Nico Bontenbal earned 1500 total points
ID: 38328250
I'm not able to replicate your problem. I don't have your data of course so I've deleted all the parameters and changed the main data set. This gives me lines with the same thickness. I'm using 2008 R2, maybe the problem only occurs in 2008.
I see there are a lot of formatting properties in the chart that use expressions. Maybe you can built the chart again form scratch and then add the formatting properties one by one. Maybe you can find the one that causes the problem this way.
Like I said in my previous post there is a warning message in the report. I don't think that is the cause but I'd fix it anyway just to make sure.
I'm also curious if the problem only occurs in preview, or also in IE, and with the various export formats.
0
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 38337802
If you solved it, I'm very curious what caused the problem.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

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

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
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…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

862 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