Microsoft Sharepoint Web Parts

SQL Bullet Graph Gauge Sharepoint Web Part

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 or a Bullet Graph. The bullet graph charts are created using Google's public Chart API. The Web Part can be used with Windows Sharepoint Services V3, MOSS 2007, Sharepoint 2010, Sharepoint 2013 and Sharepoint 2016.  The following parameters can be configured: SQL query to select the data to be visualized KPI Indicator or Bullet Graph display options Bullet Graph ranges and range colors (eg. bad, satisfactory, good)   Product Price SQL Bullet Graph Web Part 30 day Evaluation Version Free SQL Bullet Graph Web Part for Sharepoint 2013 30 day Evaluation Version Free SQL Bullet Graph Web Part for Sharepoint 2016 30 day Evaluation Version Free SQL Bullet Graph Web Part License Key per Server License USD 125.00 Web Part Installation Instructions Deployment Instructions for SP 2010

Installation Instructions:

1. download and unpack the AESQLGaugeWebpart.zip file.
   The ZIP archive contains the AESQLGaugeWebpart.wsp, the AESQLGaugeWebpart.dll and the AESQLGauge.webpart files.
   
2. download the SQL Bullet Graph Web Part Installation Instructions (PDF file, see above) 
   
3. either install the web part manually or deploy the feature to your server/farm as described in the instructions.
   

4. Navigate to a page where you would like to place the webpart and choose "Site Actions/Edit Page"

5. Add the web part to the appropriate zone. The web part is listed in the "Miscellaneous" web part gallery section
   
   
6. Configure the following Web Part properties in the Web Part Editor "Miscellaneous" pane section as needed:
   
   

   DB Connection String (SQL Server): if you use SQL Server authentication, enter the connection string as follows: UID=uuu;Initial Catalog=database;Data Source=servername where uuu = SQL Server User Account database = the database you want to connect to servername = the name of the SQL Server Example: UID=sa;Initial Catalog=Northwind;Data Source=TestSQL; Please note that the password is entered in the Connection Password field for security reasons. if you use Windows authentication, enter the connection string as follows: Initial Catalog=database;Data Source=servername;Integrated Security=SSPI; Example: Initial Catalog=Northwind;Data Source=TestSQL;Integrated Security=SSPI; DB Connection String (OLE-DB): either simply enter the physical file name of the data source file (MS Access, MS Excel, CSV files) as follows: Examples:   c:\data\northwind.mdb    d:\excel\somedata.xls   c:\data\somedata.csv or alternatively enter a fully qualified OLE-DB connection string as follows: Examples:   Provider=OraOLEDB.Oracle;OLEDB.NET=true;PLSQLRSet=true;Password=[ppp];User ID=[uuu];Data Source=[ddd]   Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\data\northwind.mdb   Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\data\somedata.csv;Extended Properties='text;FMT=Delimited' You can look up nearly every database connection string at http://connectionstrings.com DB Connection String (ODBC): either enter the ODBC Data Source name (as configured with the ODBC Data Source Administrator) as follows: dsn=MyDataSource or enter your fully qualified ODBC connection string as follows (Example): Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=; Connection Password: if you use SQL Server authentication, enter the User account passord into this field. It will be automatically encrypted for security reasons. Leave this field empty if you use an OLE-DB connection. SQL Query: Enter the desired SQL Select statement into this field. Select the following numeric values: Actual Value: is displayed as the featured measure (black bar) Reference Value: (optional) contains the comparative reference measure to be displayed. If present, this value is displayed as a red vertical bar. Lower Limit: (optional) you can either select the lower threshold value (actual values below this limit are "red") via SQL or enter it manually (see "Range Values" field below). Upper Limit: (optional)  you can either select the upper threshold value (actual values above this limit are "green") via SQL or enter it manually (see "Range Values" field below). Example (using the Microsoft Northwind database): SELECT SUM(UnitPrice*Quantity),15000 FROM [Order Details] WHERE ProductID=11 Query Placeholders: Use the {1} placeholder to pass a Filter value (via a web part connection to a Filter web part) to the query. Example: SELECT SUM(UnitPrice*Quantity),15000 FROM [Order Details] WHERE ProductID={1} Stored Procedures: Enter the name of the Stored Procedure, followed by optional parameters. Add each parameter as a "name=value" pair and separate multiple parameters by semicolons. Example (refers to Microsoft Northwind sample database): SalesByCategory;CategoryName=Seafood;OrdYear=1997   Range Values: enter the numeric values for the 3 (Bullet Graph) or  2 (KPI display) data ranges representing the qualitative ranges (as eg. "bad, satisfactory, good" or "red, yellow, green"). These values should be chosen to fit the actual data value. Separate the values by commas. The KPI display option only requires the first two values. Range Colors:  (Bullet Graph only) enter the RGB color values for the 3 qualitative ranges, separated by commas (only needed if Bullet Graph or Metro Tile option is chosen). Gauge Type: choose one of the following display options: - Bullet Graph - KPI Indicator - Gauge - Metro Tile Gauge display option Metro tile option Metro multiple tiles option Chart Width: enter the desired width of the Bullet Graph Chart in pixels Actual Value Bar Color: (Bullet Graph only) enter the desired RGB color value of the actual data value being gauged (Default:black). Reference Value Color: (Bullet Graph only) enter the desired RGB color value of the reference value being gauged (Default:red). Chart Caption: enter an optional chart caption. You can use embedded HTML tags if needed and also embed the actual value, the reference value and the percentage of actual value / reference value via the {actual}, {reference} and {percent} placeholders. Example: The actual value is ${actual} compared to our goal of ${reference} for this quarter. We reached {percent} of the goal. KPI Labels Text: (KPI only) enter the desired label values (Default: "Goal;Actual") KPI Unit Of Measure: optionally enter the unit of measure for the KPI values (to be appended to the "Goal" and "Actual" KPI values). Reverse KPI Indicators: (KPI only) display the indicators in reverse order (eg. low value=green, high value=red) Label Value Precision: enter the number of decimal places for the KPI label values. Enter the value "-1" for automatic formatting of the values. Example: Labels formatted to 5 decimal places Page Refresh Interval: enter the optional page refresh interval in minutes (0 = no page refresh) License Key: enter your Product License Key (as supplied after purchase of the "SQL Bullet Graph Web Part" license key). Leave this field empty if you are using the free 30 day evaluation version.