Plotting a line on a chart with a single value

Posted on 2011-02-23
Medium Priority
Last Modified: 2012-06-27

I have a line chart that represents the arrival/closure rates of Problem Reports during a software release. The X-axis is the time period (Weeks) and the Y-axis is the PR Count.

I’d like to add a vertical line to represent the release date. The value of the release date would be contained in a parameter that the user would supply upon report generation.

My problem is that I don’t know how I can take a single value (Release Date) and chart it so that it displays a vertical line the entire height of the Y-Axis.

Any ideas/suggestions are most welcome.

We are using SSRS 2008
Question by:RonCourteau
  • 2
LVL 10

Expert Comment

ID: 34965410

I do remember seeing similar requirement but I don't think there is a way to do that.

Here are my suggestions:
-- Instead of line use expression on weeks to make it bold for the week you want.
-- You might be able to move starting point so the chart starts "in the middle" which might give you the line but in here i'm just guessing
-- also if you have arrival / closures you might do a second Y-axis with % on the same chart as there are closely related.

Hope that helps

Author Comment

ID: 34965587
Thanks for the suggestions Emil but that really doesn't do it for me.
I need to indicate on the chart the date of a planned release, now this can be either by a vertical line  or a marker at the period that contains the release date. So for example, if I have data for 20 periods (Weeks in my case) and the release date falls on the 17th period, then I want to draw a vertical line at the 17th period.
I cannot as you suggest start the chart in the middle or elsewhere as we must report from the begining of the project to the end. Also showing a % is also not valid as a % is not indicative of the release date. The release date is provided as a parameter and is part of Project Plans not % resolution as you suggest.
Thanks again for your suggestions though.

Accepted Solution

rajeevnandanmishra earned 2000 total points
ID: 34967414

It seems that you already have the X-axis value in the run time for the release date. Isn't it possible to pass a maximum of PR Count also (as Y-axis value). In that case you will have two points actually.  
Point1: X (Release Date), Y (0)
Point2: X (Release Date), Y (Max of PR Count)


Author Closing Comment

ID: 34969151
Thanks Raj - Even the Microsoft guy on the SSRS newsgroop couldn't provide me with an answer that worked - Much appreciated.

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

597 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