Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
blas53
Starting Member
15 Posts |
 Posted - 2005-09-23 : 13:09:48
|
| Hello,I'm trying to generate a report that needs to specify, depending on the efficiency of an employee, a progress bar that fills according to the employee efficiency. For example if the efficiency is of 50% the bar should fill up to the middle. How can I achieve this?Thanks for your collaboration. |
|
|
jhermiz
3564 Posts |
Posted - 2005-09-25 : 03:42:54
|
quote:
Originally posted by blas53
Hello,I'm trying to generate a report that needs to specify, depending on the efficiency of an employee, a progress bar that fills according to the employee efficiency. For example if the efficiency is of 50% the bar should fill up to the middle. How can I achieve this?Thanks for your collaboration.
SELECT Employee, MAX(Efficiency) as MaxEffFROM YourTable GROUP BY EmployeeThen you use employee as your x-axis value and the efficiency as the y-axis value and have RS plot you a simple bar graph. This is the simplest type of bar graph in RS. You can also create trendlines and modify values on top of each bar.Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
blas53
Starting Member
15 Posts |
Posted - 2005-09-26 : 01:04:34
|
| Hello,But is it possible to graph one bar inside of a cell in a table? Because the description of the value that has to be graped can be very long and it's a property that needs to appear. Basically I need to graph the achievements (that can be a very long text) and besides it graph the percentage of the value. Can this be done? what would be the best approach?Thanks a lot for your collaboration. |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-09-26 : 09:41:25
|
quote:
Originally posted by blas53
Hello,But is it possible to graph one bar inside of a cell in a table? Because the description of the value that has to be graped can be very long and it's a property that needs to appear. Basically I need to graph the achievements (that can be a very long text) and besides it graph the percentage of the value. Can this be done? what would be the best approach?Thanks a lot for your collaboration.
I feel your pain. I have done something very similiar or had been assigned should I say. The problem is the text was too long in my case too. You will have to do the following:1) Come up with ACRONYMS or ABBREVIATIONS very short ones or even codes that represent what you want.2) Use the original reply that I said, the abbreviation or code becomes your x-axis3) Then tell RS to use the key or legend to explain to the end user what the key means. That is the best you can do.Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
blas53
Starting Member
15 Posts |
Posted - 2005-09-27 : 08:59:38
|
| Hello,Ok, I'll try and do it that way.Thanks a lot for your collaboration. |
|
|
|
|
|
|
|
|
SQL reporting services