SSRS Line Chart Issue

• srisarasu

  SSC Veteran

  Points: 214

  More actions

  September 2, 2009 at 3:43 am

  #214076

  Hi All,

  I am developing a report which has a chart control in it. The category consists of the calender months in a year

  for eg., 1 to 31-May-2008,1 to 30-Jun-2008 etc., and the Y axis consists of the values 0 to 100 with a interval of 10.

  I have plotted a bar graph for each month.The client wants a straight line from the y axis starting from y=5 to the end.

  So I have added a hard coded series to the graph and added the y coordinate as =5 and set the series type to Line,Plain.

  The problem is in the graph the line starts from the lowest value in the dataset and ends at the highest values in the dataset.It does not start from the y axis. Does anyone know how to resolve this issue? Is there any other way to plot a line starting from the y-intercept that runs till the end.

  Regards,

  srisarasu

• satish.t

  Mr or Mrs. 500

  Points: 521

  More actions

  September 2, 2009 at 12:07 pm

  #1048332

  Hi There...

  I found a round about for you....

  First add a row in ur data with value 0 for x axis which default changes to a date say suppose 01/01/1990 and 5 for y axis...

  Then on the category axis properties set mininmum as the 01/01/1990...

  Then you will get the start at y intercept...

  Using expression u can control the labels on x axis...

  Hope this helps you...

  cheers

  satish

• srisarasu

  SSC Veteran

  Points: 214

  More actions

  September 2, 2009 at 9:40 pm

  #1048524

  Hi Satish,

  Your idea sounds great.Let me work on it.Thanks.

  srisarasu.

• becklery

  Hall of Fame

  Points: 3315

  More actions

  September 4, 2009 at 8:53 pm

  #1049657

  Hi, srisarasu.

  You can try RAQ Report[/url]. It provides many useful charts for users, and it is easy to make them. An example of line chart is shown below:

  

  RAQ Report: Web-based Excel-like Java reporting tool[/url]