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

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

Need to create Chart in SSRS 2008

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
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

View Complete Post

More Related Resource Links

How to create Range bar chart i n SSRS 2008

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

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

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

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 to align data in Chart legend in SSRS 2008?

Hi,I have created a chart of type 3D pie.  I put a String field for Category and Sum(numeric field) for Data.I wanted to show the legend as Category field and Data field and it's displaying as i set.Now how to make alignment of Data in legend, so that my numeric fields should align Right and String field should align Left.  I can make whole legend alignment but I want to make only the numeric field in the legend to align Right.Is it possible or there any work around?Please let me know.

need help in Chart in SSRS 2008

HI all, I have to create report in the basis of Chart,in which i have to take Column A which include date.but i want to show hours on that axis corresponding to that date.   Please help Amit

Checking weather a chart is hidden or displayd by using an Expression (SSRS 2008)

Hello, I want to check weather a chart is hidden or displayd by using the Expression of a Text Box that toggles display of that chart. Therefore I need to call the chart in the Expression. Something like this: =IIF(ReportItems!Chart2.Hidden = False ... But obviously charts are not regarded as report items by ssrs!?!? Thanks Axel

creation of Chart in report ssrs 2008

HI All, I have to create report based on the chart in ssrs 2008 in which i have to use different bar for different coulmn,Kindly suggest how to start the same.   Shraddha

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.

SSRS 2008 R2 - Line chart labels - visibility based on expression?


I would like to control the visibility of a data label in a line chart using an expression. For example, I have a requirement to show the data label for two compariable data points in a line chart where the horizontal axis is time (Q1, Q2, Q3, etc...) and the data points are determined based on a selected parameter. The basic idea is that a user can select to view Q3 as the end point of reporting and the chart will graph a complete time line (e.g. FY 2001 thru FYXX Q3) but only show the label for Q3 and prior year Q3.

I have tried to build an expression in the visibility property of 'Chart Series Labels' but this does not appear to work.


SSRS 2008 Scatter Chart


I haven't seen a way to create text labels for the y-axis of my scatter chart.  As a quick fix I just created labels outside of the chart and positioned them near the major tick marks.

On the x-axis of the scatter chart I have been able to create text labels.  Sometimes the text is long which the chart then wraps so that the labels look nice and neat.

The problem is that if a text label on the x-axis is too long the chart's height is reduced.  So then the tick marks on the y-axis don't match up with my text labels that I created outside of the chart for the y-axis.


Is it possible to create text labels for the y-axis of the chart?  OR is there a way to define a height for the chart area?

SSRS 2008 r2 line chart primary and secondary category axis


I want to plot series in a line Graph on UTC time which has to be placed on Primary category axis. The secondary category axis should just display the correspoding PST time(No series need to be plotted on this). Is there a way to achive this?

SSRS 2008 chart Scalar axis, repeating the datapoints


In the SSRS 2008 chart, I made the x axis scalar and it’s a date type. On Y axis i have a simple "count" (number) corresponding to each date.

Now the x axis always has 9 points regardless of months i return from query. Like say i have data for only 8/31/2010 then i get display like 9 data points on x-axis saying Aug 2010 and on one of those, i get the count value.

If data points are more than 12 then graph is looking nice otherwise same problem of repeating the month values.

Same problem the with day wise graph too. If data points are more that 5- 10,  day wise graph looks good. otherwise some days points get repeated.

Can anybody suggest me the solution ?


Can we show a line chart on multiple pages with page breaks? SSRS 2008


Hi there,

I am using SSRS 2008. I have a line chart which queries a huge dataset and shows the datapoints really close to each other that the labels and grid-lines are overlapping onto each other. http://oi54.tinypic.com/2vifrb9.jpg

Is there a way to split the chart and show it on different pages.? Thanks in Advance :)


SSRS 2008 R2 Bubble chart


We created bubble charts with ease using Microsoft Excel. Now we wanted to implement the same using SSRS 2008 R2. But, it seems to be too complicated. This is the actual requirement

The X and Y axis are secondary and we are taking the Logarthmic scale for both the axis.

The bubble size is dependent on a field. Tried all possible ways but not able to replicate as Excel

Sample Data

Count   Data1 Data2

123      0.03  0.05

Like that. Data1 should be Y axis, Data 2 would be X axis and Count determines the bubble size. Its pretty straight forward in excel and we were not able to figure out what exactly is going wrong. The dataset is pulling the same values that are in Excel.

How to bring the stripe line into fore ground in a ssrs 2008 chart


i have created a 100 % stacked bar chart report in ssrs 2008.

in that chart created a stripe line for showing current week data.

i cant able to see  the stripe line fully.

is there any way to bring that stripe line into fore ground?

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