Solved

Plotting a line on a chart with a single value

Posted on 2011-02-23
4
869 Views
Last Modified: 2012-06-27
Hello;

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
Thanks.
Ron...
0
Comment
Question by:RonCourteau
  • 2
4 Comments
 
LVL 10

Expert Comment

by:itcouple
ID: 34965410
Hi

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
Emil
0
 

Author Comment

by:RonCourteau
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.
0
 
LVL 9

Accepted Solution

by:
rajeevnandanmishra earned 500 total points
ID: 34967414
Hi,

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)

0
 

Author Closing Comment

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

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MS SQL tables, .net application and ETL connundrum 3 53
This query failed in sql 2014 5 29
Find SQL query used by application 3 17
TSQL query to generate xml 4 31
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

813 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

11 Experts available now in Live!

Get 1:1 Help Now