The SQL Bullet Graph Gauge Web Part allows to display data values from the specified SQL Server database, OLE-DB or ODBC data source as either a KPI indicator, a Bullet Graph or a gauge.
For configuration details see also /apps/page.asp?Q=5782
Webpart Homepage & Download »
Please enter a comment below if you want to give feedback or have suggestions for improvements:
| User Comments |  Post a Comment |
Eric Gonzalez
9/14/2023 18:16 | How can i Get this to work i would like to see a Tile for each office
parameters=Reports
query=Select Office,Units,BreakEven from (Call spGetBreakEven(curdate() -14, curdate()) )as a;
rangevalues=0,100
rangecolors=ff0000,ffcc33,00cc00
type=Gauge
width=150
caption={actual}
caption=font-size:24px
kpilabels=Units,BreakEven | | Juerg
9/15/2023 12:32 | Eric,
please also specify your database connection via the below parameter as eg.:
connection=UID=sa;Initial Catalog=Northwind;Data Source=YourSQLServer
Please see a collection of examples of connection strings here:
/apps/page.asp?Q=5782
| | Eric Gonzalez
9/15/2023 21:25 | I use that parameters option because it refers back to a file that has the connection string using the AESQL webpart. Will this webpart allow me to do that also? | | Eric Gonzalez
9/29/2023 20:00 | is there a way to have the Range values pull from the SQL Query?
Select X as [Actual] , Y as Goal
RangeValues=0,acutal,reference | | Juerg
10/2/2023 11:49 | Eric,
you can select uo to 4 values via the SELECT statement:
SELECT ActualValue,ReferenceValue,LowerLimit,UpperLimit FROM ..
This allows you to dynamically select the range transitions point.
Please also note that the SQL Gauge web part currently does not support the “parameters” configuration option as the SQL Query Viewer web part. Would this be important for you ? |
|
connection=enter the database connection string