.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

[RS 2008 R2] Advice for Multi-series stacked chart

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


I need an advice about the layout of a multi-series stacked chart (which I hope is the correct way to realize my report). The data I need to draw has the following structure (aggregations have already been calculated in the database query due to the high amount of data):

Date             Priority    Value
2010-09-19   A             48
2010-09-19   B             50
2010-09-19   C             45
2010-09-19   TA A        11
2010-09-19   TA B        18
2010-09-19   TA C        2
2010-09-19   Total        143

The chart must contain Date on X axis, the Value on Y Axis and stack in the same chart area 7 different graphs according to priority field:
- 4 must be line graph (Priority = A, B, C, Total)
- 3 must be column graph (Priority = TA A, TA B, TA C)

Here follows the way I conceived the chart:
- Date field goes into Category Groups
- Priorit

View Complete Post

More Related Resource Links

Range bar chart having multi-color bars + SSRS 2008

Hi, I want to display 2 different colrs on the same bar in range bar chart. My chart is displaying project risks (MS project kind of chart). Each risk has its own start date, end date. In case of dependent risks, the start date of dependent risk becomes the end date of the risk on which it depends. Each risk has 2 parts. Lost opportunity & Remaining opportunity. I want to display Lost in red & remaining in Green. Can I display 2 different colors on the same bar? Regards, Neeraj

How do I create a stacked column chart over yrly/mo series/category?




I would like my output to look like this:

2009          2010


|__c__|    | __b__|    

|__b _|   |   a      |

|   a   |   | _____|


where both of the stacked bars represent data for the month of January such that each month would have it's own two years worth of stacked bar data...please help.

show customized groups in series field in a stacked bar chart



Here I have one doubt, need your help.

I am creating a stacked bar chart in report designer, and I have created the Dataset.

For instance: I drag and drop Count to data field, year to the category field, createdby to the series field. Now I assume that createdby have values: v1,v2,v3,v4,v5,v6. I want to group v1,v2 into Value1, and show in green color; meanwhile group v3,v4,v5 into Value2, show in red color. and do not show v6.

In the final stacked bar chart, I want only Value1 and Value2 shown in series field.

Can you tell me how can I filter v6 and create the two groups? thanks!


Connie Zhu

crystal report -visual studio 2008 dual axis chart (bar & line)


dear all, 

i use crystal report integrated with  vs.2008, and i want to make chart with dual axis (bar & line).

i have used bar chart and input the data with 2 values..

then in chart options > template, i activated the dual axis..

my question is, how i can change the 2nd value with line chart not bar chart??

i'd tried to find the right settings in "chart options" but still can't find the solution.

for information in "chart options" there are 4 sub menu : template, general,titles,grid..

i read in a tutorial there's more sub menu called "series" in crystal report (stand alone version)..

is it possible doing it in Crystal Report VS. 2008?

please,, i need your advice and solution..

Thanx before..


Stacked Column Chart: Workaround for busted InsertEmptyPoints

I had to struggle with this a bit so I'm gonna share what I figured out. To make a stacked column chart from a SqlDataSource you need to use DataBindCrossTable like this... CHART1.DataBindCrossTable(SqlDataSource1.Select(DataSourceSelectArguments.Empty), "proceso_estado_nombre", "max_fecha_final", "valor", "") Now, each series created needs to be converted to StackedColumn type, which you do like this... For Each series As DataVisualization.Charting.Series In CHART1.Series    series.ChartType = DataVisualization.Charting.SeriesChartType.StackedColumnNext The problem at this point is that the chart wont work if you don't have the same number of points in each series and each set of points should have the same X values. So to fill in the empty points in each series you can use InsertEmptyPoints like this... CHART1.DataManipulator.InsertEmptyPoints(1, DataVisualization.Charting.IntervalType.Months, series.Name.ToString) However, when I did this I got inconsistent results. See below... <Series>    <Series Name="Terminado" Legend="Default" XValueType="Date" ChartType="StackedColumn" ChartArea="ChartArea1" ToolTip="Terminado: #VALY{C0}">      <Points>      

Dual values in Column chart Y axis in SSRS 2008

Hi,  Any one pls tell me how to show dual values in Column chart Y axis. Example: Im showing Total Number of clients in the Y axis of column chart My Requirement is In that Y axis column chart also  i want to show differently of Inactive clients from total number of clients. how to do this pls help me. Thanks in advance. TotalnumberOf clients :  1000 InActive Clients : 200 among TotalnumberofClients      

Line Divider i n Column chart in SSRS 2008

Hi,  Any one pls tel me how to do the single line divider in Column chart in SSRS 2008 example: --------- |               | |     20      | ---------- |       100 | |               | -------------------------------   i want to show the above example. Thanks in advance Regards, Abdul2010

Missing Points in Chart Series

Okay so I have 3 series that are created from Cross Table Data Bind. Unfortunately some of the points are missing. Is there an algorithm I can use to cycle through the datapoints for each series and insert empty points to the correct spots so that my data is displayed correctly?

reporting services xy scatter chart with three data series

Hi, I have a report that includes an XY scatter chart with three data series.  Two of the data series are + and - tollerance bands and the thrid data series is the test points.  The data displays in the graph but I only seem to be able to get all three series to display as a line or all three to display as data points.  I need the tolerance bands to be a line and the test point to be displayed as data points without a line joining them up. Please can you provide a solution.   Thanks

Please Advice SQL 2008 Standard Edition

·         I have a issue with subscriptions since we have SQL 2008 Standard edition and i found out that Data Driven Subscription are disabled. We have about 100 reports subscribed by our internal & external customers. I have a DB "Prices" In that we have 4 Tables, Analysts,Users,SalesReps & Sub Sales rep the subscriptions are by anyone and everyone from these 4 tables.... we have a Project thats in Build in sql server 2008, which is a repository for all our 100 reports....basically what we are trying to do is based on Relationship, security level and user hierarchy they can access the reports... Any ideas will help ???????????FM

ReportViewer 2008 multi-select parameter alignment

We are using SSRS 2008 SP1 & ReportViewer 2008 SP1. The multi-select parameter options are left aligned in the drop-down listbox on the Report Server but when run thru ASP.Net & reportViewer, they are aligned in the center of the drop-down list. This is very problematic because the width of the drop-down is also narrow compared to the text size of the fields. I tried wrapping the ReportViewer in a Div tag (<div style="vertical-align: left; text-align: left">), but still no joy.  Would appreciate any help thanks.

sql server 2008 cluster multi instance

we have a cluster with 2 nodes and we are thinking to add another instance so that node 1 takes care of instance 1 and node 2 takes care of instance 2, and at anytime they are watching each other's back. How is this done???? what is the procedure? thanks.  

Regarding WPF Line Series Chart how to set this