Solved

ssrs progress bar?

Posted on 2011-09-08
4
1,962 Views
Last Modified: 2012-05-12
Would like to display a bar representing percent complete value on a scale of 0 to 100 (like a progress bar).  Databar doesn't seem to fit the bill (don't have vertical axis data),  dialgauge has too much stuff and looks blurry, chart 100% stacked bar seems to kindof fit the bill but I only have one category and it looks odd, also too much stuff there.  The value of the percent is a field in my dataset, how do I display a simple bar with it?
0
Comment
Question by:MariaHalt
  • 3
4 Comments
 
LVL 2

Expert Comment

by:awarren85
ID: 36507929
What I usually do, if you can express the data in a table, is to drop a horizontal bar chart into a group header cell into that table that shows the data, then for the values of that chart, put your percentage values.
0
 

Accepted Solution

by:
MariaHalt earned 0 total points
ID: 36524507
I ended up inserting a horizontal linear gauge and stripping away much of the dispaly features and got exactly what I was hoping for.  In the Gauge Data popup, I set LinearPoint1 = my data field that contained the percent I wanted to use, set the scale from 0 to 100, got rid of major and minor tick marks and the "caution" zone.
0
 

Author Closing Comment

by:MariaHalt
ID: 36553478
Hope this helps someone else one day.
0
 

Author Comment

by:MariaHalt
ID: 36524522
Tried chart, didn't get results I was hoping for.  Played around with gauge and finally got what I wanted, hope this helps someone else someday.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question