Solved

SSRS 2008 Line chart help

Posted on 2011-09-29
7
520 Views
Last Modified: 2012-08-13
This seems like a very simple report that I am trying to deploy. It is essentially a rolling 12-month sales report across departments and users.  I have attached a screenshot from excel showing what I am trying to accomplish. My sql query returns the table data shown in the grid. I just can't figure out how to display it as a line chart in SSRS. (One click via Excel, so I have to assume this is something I am just missing).
Thanks! screenshot
0
Comment
Question by:dbrennecke
7 Comments
 
LVL 25

Expert Comment

by:TempDBA
ID: 36861864
0
 

Author Comment

by:dbrennecke
ID: 36979698
The 2005 tutorial doesn't seem to help me out with the 2008 environment. I was familiar with 2005, but not 2008.. and I can't seem to figure this out.
0
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 37004784
Here's another link to help you out: http://www.simple-talk.com/sql/reporting-services/get-started-with-chart-development-in-reporting-services-2008/

The article above creates a chart more or less like what you're looking for: timeline on the X-axis, amounts on the Y-axis, and several series into one chart.  The only difference is that it's a bar chart instead of line, but that's just a couple of clicks to switch between them.

As an extra: for some additional chart optimization tips, I can recommend the following article: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/A_1644-Chart-Optimization-Tips.html
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 37144330
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Get the latest status 8 32
Querying data from 3 SQL tables 2 32
SQL view 2 27
SQL Function NOT ROUND 9 10
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

777 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