SSRS 2008 Column Chart with Line

Who is online?  0 guests and 0 members
Home  »  Blogs  »  MikeDavis  »  SSRS 2008 Column Chart with Line
 
0
/5
Avg: 0/5: (0 votes)

Comments (11)

Alexx
Alexx said:

Hi Mike, 

do you know if it is possible to hide a trend line in SSRS 2005 in the same way that you explained here?

 

Thank you!

5/31/2011
 · 
 
by
MikeDavis
MikeDavis said:

I believe the series in 2005 had a visiblity property. If so, then yes, you should be able to hide it. Anything with a visibility property can be hidden.

5/31/2011
 · 
 
by
JIMSS
JIMSS said:

Mike,

    I have a situation similar to your example, but a little differant.  I have a situation where by (to make it simple) I have 3 reps and need a total, however I only need a line graph.  My "numbers" is money or sales.  I want 4 lines, one for each "rep" and a total line.  I have made 4 series of Sum(sales) and using a visibility expression in 3 of the 4 similar to how you do it here and then a total that does not have anything hidden to get the total.  I, also, have an axis of time, which the graph should give the amount of sales by rep and a total across a span of time.  1.  Is there a way to pull the values of "rep" without hard coding a series for each?  2.  Mine looks fine in design with my 4 lines and a legend for each "rep" and a total, which is what I would think it would be, however when I preview it, I only get 1 rep and the total.  Do you have an idea of what I am missing?

 

 

6/27/2011
 · 
 
by
MikeDavis
MikeDavis said:

JIMSS, I would not hard code in the Rep for those. I would create a series for Rep to get each rep. Then in the T-SQL you can create a "total rep" in the data source to show the total.

6/28/2011
 · 
 
by
JIMSS
JIMSS said:

Thank you, that worked.

6/28/2011
 · 
 
by
karthi.kamal
karthi.kamal said:
Mike I also Struggle with the same problem in SSRS 2005.i already drawn the Line graph for the three columns from the Sql Serever 2005 .But now i need the Trend Line for these Three lines in my graph.the trend line is applicable only fir bar chart in SSRS 2005 but how can i implemented in Line chart either 2005 or 2008 .I need your help ASAP. Thanks In Advance
5/2/2012
 · 
 
by
MikeDavis
MikeDavis said:
karthi.kamal you will need the data for the trend line in your data set. There is no trend line option.
5/2/2012
 · 
 
by
karthi.kamal
karthi.kamal said:
mike i had the data for single line graph (example i had Rank detail for the individual person) by using this data only i will calculate the trend line data.i also check the the formula Y=MX+C but its applicable only for Bar chart .for bar chart only plot area should be Enable in SSRS 2005 .This is the link I was refereed http://ericung.blogspot.in/2011/07/ssrs-2005-bar-chart-adding-linear-trend.html I need the same trend line for the Bar-Chart in SSRS 2005.
5/3/2012
 · 
 
by
user709565
user709565 said:
You are Awesome Mike, Explained it in a very easy way
4/15/2013
 · 
 
by
andymc123
andymc123 said:
Very helpful post, thanks! This helped me re-create a legacy chart with bookings and shipments as bars, and the budget as a line. You would not believe the puch back when I tried to replace it originally with just a bar chart. :)
6/13/2013
 · 
 
by
user461063
user461063 said:
Excellent post. I'm using SSRS 2012 and was able to achieve these results using report Builder 3.0. Thank you very much.
11/21/2013
 · 
 
by
Blogs RSS Feed

MikeDavis's latest blog posts

Blogs RSS Feed

Latest community blog posts