all groups > sql server reporting services > september 2007 >
You're in the

sql server reporting services

group:

graphs on line detail



graphs on line detail locoytravieso
9/7/2007 9:38:22 AM
sql server reporting services: Hi All-

In SQL Reporting Services is it possible to have a graph on each line of
detail or only on summary (or total) data? If this question doesn't make
sense, here's an example....

I want to make a disk space utilization report for MOM2005, I want each
server to be on one line and then a graph to represent each volume and how
full it is with a specific color to indicate criticality (like green for
values of 1-80%, yellow for values of 80-95% and red for 95% on up).....
Something like this:

0%
100%
SERVER 1 |
| C: drive 50% full ***************
(green)
| D: drive 1% full * (green)

SERVER 2 | C: drive 75% full *************************
(green)
| D: drive 99% full
****************************** (red)

SERVER 3 | C: drive 85% full **************************
(yellow)

Any help with this request would be most appreciated. I think this would be
a very nice report to have.

Thanks,

--GREG--

RE: graphs on line detail Jimbo
9/7/2007 1:24:06 PM
Why not have one horizontal bar chart with a bar for each server?





[quoted text, click to view]
Re: graphs on line detail Greg Tompkins
9/7/2007 4:32:48 PM
Hi Jimbo,

That would be "okay" if there was only one drive per server. I want to see
the utilization on logical volume windows sees.

Thanks,

--GREG--


[quoted text, click to view]

Re: graphs on line detail Jimbo
9/7/2007 7:16:00 PM
That's ok, you can feed titles and data for all the bars to represent
anything you want!




[quoted text, click to view]
Re: graphs on line detail NH
9/10/2007 9:08:02 AM
You could create a subreport with just your chart defined on it. Then put the
subreport into the row detail on your main report.

[quoted text, click to view]
AddThis Social Bookmark Button