.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Is it possible to create a graph like this in SSRS?

Posted By:      Posted Date: September 21, 2010    Points: 0   Category :Sql Server

I am new in SSRS and got the request from user to have report as below. images by uppicweb.com

I think the difficult things are

1) The total column in left hand side.

2) The small up/down inside each series. Thank you for the comments.

View Complete Post

More Related Resource Links

SSRS 2008 Graph Type?


Greetings -


I am required to plot the following graph in an SSRS report.


Sum of Total Credits to be shown on Positive side and total sum of Debits for a month on negative side. I have created a query which retrieves all the expenses for the month and sums them up before feeding the same to the graph for plotting. Both values returned are positive integers.


(Sorry for the diagram below, i tried to paste an image but it didn't work)

Cannot create a connection to data source !!!! SSRS 2005

I cannot get this error resolve either for myself or any users, and I'm actually part of the Admin group!  Furthermore, a user with whom I'm tring allow to view this report keeps getting prompted for their windows username and password.  I thought that since this datasource was set to Windows Authentification that it would just pass it through? I'm pulling my hair out at this point: Screen Shots: http://www.webfound.net/datasource_connection.jpg http://www.webfound.net/datasource_connection2.jpg http://www.webfound.net/datasource_connection3.jpg Also As far as I know, I've given sufficient permissions to the right logins and right users on my SQL Databases and related stored procs that the datasets (not datasource) run An error has occurred during report processing. Cannot create a connection to data source 'datasourcename'. For more information about this error navigate to the report server on the local server machine, or enable remote errors

How to create Range bar chart i n SSRS 2008

  Hi How to create Range bar chart i n SSRS 2008 amit

Need to create Chart in SSRS 2008

0 Hi Sorna, I want data in this format as below   | |                                           b________                 b________ |                   a_____                               a________ |_____________________________________________ 0      1           2      3              6               7                  24 time   X- axis -- Time Y - Stand jsut for single name.showing dotted but consider as simple y axis. Name A suppose to perform two work a,b and he perform a in 2Am to 3Am while b in 6 Am to 7 Am,now i want to create the bar chart as above please suggest how to do.   I have seen this url ::http://www.sqlservercentral.com/arti

Create dynamic dropdown list when we export data to excel using SSRS.


Hi All,

I have assigned a work to create a report, that should render in excel with dropdown list. i.e. report should contain a input parameter as a table names, when user selects the table name, report should show only the field names of the selected table. Some of the field name have look up values that values should be displayed as dropdown when we export to excel.

Can any one have any idea how to proceed with this report?



How to use .XSD file as DataSet to create SSRS report?



I am  planning to create a SSRS report and lunch it in a ASP.NET web application (not using report server). Since the dataset need to be manipulated before used to generate report (some data fields of tables need to be filled  using data got from other system using COM+ components) , I hope I can use a .XSD file as the DataSet to create SSRS report and bind data source dynamically in code. It is not a problem using Crystal Report, but I have no idea how to do it either in Report Designer or in VS 2005. Please advise





SSRS 2005/2008 - Chart with bar graph not generating on subsequent executions of report even with mo


For a report executed from Report Manager that has a bar chart component, regenerating the report via refresh or view with same input parameters either gives a different result that is garbled or an empty chart (2008) or no chart at all (2005). I have the report set up to not do any caching, so that does not seem to be the issue. Is there some chart option I may need to set to get the proper chart display.

How to Create SPC Histogram chart in SSRS 2008


Hi All,

I need to create SPC Histogram chart in SSRS 2008 to represent Cp, Cpk etc. i can calculate all this Cp, Cpk but not getting how to represent as a chart in SSRS 2008. I know there is no readymate  template availavle in SSRS for SPC but is there any other way to draw histogram chart ?

You can see the SPC histogram chart example on this link : http://www.qimacros.com/qiwizard/process-capability.html

Any help in this regard will be highly appreciated.

Thanks & Regards

Nipendra Garg

Line Graph is not showing up in SSRS 2005


I am creating line graph using BIDS 2005 ( VS 2005). When I select chart type line , I do not see a line graph insteady Scatter dots in graph surface. I have tried to add screen capture in this question but for some reason I can not paste here. I can easily switch my chart type into Columan,Bar,Pie, XY (Scatter),...etc except Line chart. Any idea or suggestion greatly appreciated!!! Thanks,



Pass delivery method, email address to create SSRS subscription using VS2005



I have created SSRS reports and built a user UI to run these reports. Now when creating SSRS subscriptions in report Manager, is it even possible to programmatically pass the delivery method (email or file share), To email address, scheduled time and date, etc from my front-end UI to the Report Manager?

Any help will be greatly appreciated. Thanks

Report - Drill down/Expand details? - how do I create this report in SSRS


I'm having trouble making this drilldown/expand details report. It is probably simple - but is beyound the basic drill down examples that I have found.

My data has multiple rows per product because 2 of the columns are joined with tables that include multiple rows per product. This is related products and prices for quantity intervals.

Is it possible to use grouping so that I could have these show as 1 row per product and then be able to expand the information

Any solution will do – it could be like this:

How to create 3 tier application using LINQ

As you know that in 3 tier architecture there are three layers

User interface layer. (Is our Form in Windows application and .aspx page in Web application)
Data Access layer. (Which provides interface between Business logic layer and Database)
Business Logic layer.(Which stores your application logic)

Create ToolTip for GridView Header

The following allows you to add a tooltip to the header links of your GridView, a feature that is lacking.

Create And Run Excel Macro At Runtime in C#

You've been tasked with writing a Windows Form application using the .NET Framework that interacts with Microsoft Excel. If you are new to working with Excel in .NET and are having trouble learning how to format certain cells or cell ranges, then this little tip will come in handy. Rather than scour the internet hoping to find the correct set of constants or method syntax for formatting your spreadsheet, use the built in tools in Excel to write the familiar VBA code for you. Then, you can paste the VBA code generated by Excel into the sample C# code below and run it dynamically at runtime.

Create and Use a Typed DataSet by Using Visual C# .NET

This article shows you how to create and use a typed DataSet in a small Web application. Typed DataSets, which inherit from the DataSet class, create first-class members of a DataSet's DataTables and DataColumns, yielding the many benefits that come with the use of strong typing.

Connestion string create any database server

This links important to how to create connection string to any data base sever.

Dynamically Create Controls in ASP.NET by Using Visual C# .NET

This article demonstrates how to dynamically create a control for an .aspx page. The sample project does the following:
Creates two TextBox controls.
Verifies that the contents (TextBox.text) and the attributes of the TextBox are saved across posts to the server.
Illustrates handling events that are posted by a dynamically-created control
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend