SSRS 2008 - Bar  width not consistent in bar graphs

Posted on 2012-08-16
Last Modified: 2012-08-27

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
Question by:comtec100
    LVL 22

    Expert Comment

    by:Nico Bontenbal
    Try setting PointWidth to 1 and PixelPointWidth to 10 (or some other value).
    LVL 22

    Expert Comment

    by:Nico Bontenbal
    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.

    Author Comment

    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 ?
    LVL 22

    Accepted Solution

    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.
    LVL 22

    Expert Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Suggested Solutions

    Title # Comments Views Activity
    SSRS report builder 3.0 6 29
    SQL Calcualted Field 13 43
    SSRS 2005 Matrix Column Break 1 40
    SSRS Report Runtime Error 20 32
    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…
    Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    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

    16 Experts available now in Live!

    Get 1:1 Help Now