.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

dynamic min value in y-axis for line chart

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
How to set dynamic min value in y-axis for line chart in ssrs 2005 give me examples Table Test rid Percentage Reason1 98 Reason2 89 Reason3 87 Reason4 82 Reason5 91 Reason6 96 example: y-axis should start 80(if it is 70 it should start 70) by dynamically

View Complete Post

More Related Resource Links

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..


Line chart Category Axis labels not displaying


I've got a few series of data (counts) that I've summed by month and year. So, the data looks like 

Value 'June 2010' 'July 2010', ....

Open       3                5  ...

Closed     6                10....


I've got a line chart of this data. The issue I have is on the category axis, I have the months as the value. However, only a couple of the 12 months are being displayed. The chart is populating properly, but I want every month to list out on the category axis. How can I do this, since my category type is a string? What should I set the interval, etc. to? This seems pretty basic, so I must be missing something simple.



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?

Need help to display the axis dynamically in Line chart



I created one date hierarchy like year-->quarter-->Month and i'm creating one parameter YeartoMonth (year i'm using date hierarchy)

i want create one line chart with hierarchy axis it means

when i select any value from yeartomonth filter i want display those valus in axis of the line chart

like if i select Q1 , Q2,Q3 from 2010

i want to display the Q1,Q2,Q3 as the axis for that line chart

it means i want pass those values dynamically based on filter selection

Please can you help me to solve this issue

Thanks in advance...

Chart X axis is in Time



My application work in this ways. I got a database collect data from 20 sensors. Database holds Temperature and DateTime data/Records from sensors. So i would like to make it whenever i view the chart, it will plot a line chart one by one according to the temperature and timestamp(DateTime). Which mean my X axis is a colleborate time on that particular date. Anyone did this before or advice ? Thanks.

I already design a in the way that the line chart will plot base on both dropdownlist, Sensor ID and Date. So it will work like whenever i select a Date or ID it will read the records from database table temperature.

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

Display name of months on x-axis in a chart

Could you please let me know if there is any expression which can be used to display the months on x-axis of the column chart. I've tried playing with the Axis option trying to change the interval type to "months" but it is not giving the result. Thank you.

Hide background horizontal line in Chart

Hello, I am using SSRS 2008.  I have a simple question which i hope someone might be able to help me with. I have a series chart The chart area has horizontal lines for which i see no option to hide or remove before report rendering.  Is there a way to control this so that my chart can have a blank background look.   Regards

Alternate lables are displayed along x axis in chart web part for column chart type

HI I am using Chart webpart of Sharepoint 2010. I am connecting this webpart to my custom list having two coulmn Title  (string) and Count (numeric) and using Column chart type i am displaying data in web part. Each column in chart represents one item in list and displyed along x axis, while y axis represents count. For more than 9 columns in column chart (i.e. more than 9 itmes in list) in chart web part only alternate lables are displyed along x axis. Any help in this will be appreciated.

stack chart line at 0 value

i have stacked chart  i want only grid line at 0 value all other grid lines should be visible false how can i do that 

set the proerty from code behind line chart wpf

< Style x:Key = " InvisibleDataPointStyle " TargetType = " c:LineDataPoint " > < Setter Property = " Opacity " Value = " 0 " /> < Setter Property = " Background " Value = " Yellow " /> </ Style >

Regarding WPF Line Series Chart how to set this