Solved

Excel Graph in SSRS report

Posted on 2013-12-12
5
424 Views
Last Modified: 2013-12-21
Hi All,

I want to achieve the excel graph in SSRS, I tried to do so , but unable to achieve.

Please find the attached screen-shot of the same and let me know if any clarification required.
Screen.jpg
0
Comment
Question by:prashant04
  • 3
  • 2
5 Comments
 
LVL 12

Expert Comment

by:Tony303
ID: 39715216
Yes this is possible,
You can create a stacked bar chart very similar to your excel one.

How experienced in SSRS are you.


Here is an article.


http://social.msdn.microsoft.com/Forums/sqlserver/en-US/33210df6-15df-4b00-a7f2-e6f12eb1d649/ssrs-stacked-column-chart-with-two-value-series?forum=sqlreportingservices
0
 
LVL 12

Expert Comment

by:Tony303
ID: 39715233
0
 

Author Comment

by:prashant04
ID: 39715780
I Tried the same solution, however its work partially, want two stacks like Actuals and baselines as per the excel. as per last solution I am able to achieve only for actuals, I am unable to add another stack on the same chart.

Please suggest.
0
 
LVL 12

Accepted Solution

by:
Tony303 earned 500 total points
ID: 39717816
Hi,
I think you need to make a Category Group in the chart and have the field that contains the words Actual and Forecast.

That should give you the x axis with 2 stacked bars.

Do a google image search on ssrs stacked bar, you will see some examples I'm sure.

Can you post the graph and the chart data expanded on the right just to see what you have.

T
0
 

Author Comment

by:prashant04
ID: 39733678
I tried and its working, Thanks.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
This video discusses moving either the default database or any database to a new volume.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

707 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

18 Experts available now in Live!

Get 1:1 Help Now