Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS Line Chart Issue Expand / Collapse
Author
Message
Posted Wednesday, September 02, 2009 3:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 10, 2013 1:03 AM
Points: 2, Visits: 44
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
Post #781290
Posted Wednesday, September 02, 2009 12:07 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, November 11, 2010 2:25 PM
Points: 23, Visits: 75
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
Post #781694
Posted Wednesday, September 02, 2009 9:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 10, 2013 1:03 AM
Points: 2, Visits: 44
Hi Satish,
Your idea sounds great.Let me work on it.Thanks.
srisarasu.
Post #781922
Posted Friday, September 04, 2009 8:53 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 14, 2010 9:09 AM
Points: 141, Visits: 187
Hi, srisarasu.
You can try RAQ Report. 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
Post #783236
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse