AMREIN ENGINEERING Agenda/X | Sharepoint | Solutions | Partners | Support | Search | About us | Home  
  AE SQL Bullet Graph Sharepoint Web Part Deutsch English  


Sharepoint Web Parts  

Digital Clock Web Part  

Stock Chart Web Part  

Stock Quotes Web Part  

Dilbert Web Part  

Quote of the Day Web Part  

"Spotlight On.." Web Part  

"Tip of the Day" Web Part  

Lightbox Web Part  

Weather Web Part  

Slideshow Web Part  

Currency Rates Web Part  

Media Player Web Part  

YouTube Player Web Part  

Map Chart Web Part  

Google Chart Web Part  

Bullet Graph Web Part  

RSS Feed Ticker Web Part  

SQL Viewer Web Part  

Google Map Web Part  

Quick Poll Web Part  

Quick Survey Web Part  

Audio Player Web Part  

Google GeoMapper Web Part  

SQL Chart Web Part  

Exchange Calendar Web Part  

Podcast Web Part  

Filter Web Part  

Image Rotator Web Part  

Navigator Web Part  

KPI Web Part  

Page Hits Web Part  

Picture Menu Web Part  

Timer Web Part  

Van Gogh Web Part  

SQL Bullet Graph Web Part  

User Spotlight Web Part  

List View Web Part  

Staff Directory Web Part  

Birthday Reminder Web Part  

News Carousel Web Part  

Team Members Web Part  

Christmas Web Part  

Classifieds Web Part  

Google Earth Web Part  

Timeline Web Part  

Banner Rotator Web Part  

AZ Index Web Part  

Blog Roll Up Web Part  

Discussion Roll Up Web Part  

Document Roll Up Web Part  

News Roll Up Web Part  

Task Roll Up Web Part  

Calendar Roll Up Web Part  

Quick Form Web Part  

Twitter Web Part  

Upcoming Events Web Part  

Welcome Web Part  

Color Calendar Web Part  

Image Carousel Web Part  

Metro Grid Web Part  

Goal Thermometer Web Part  

Swipe Gallery Web Part  

List Rotator Web Part  

List Search Web Part  

Flash Rotator Web Part  

Accordion & Tabs List Bundle  

Accordion List Web Part  

Tabs List Web Part  

Microblog/Chat Web Part  

Toast Notifications  

Vacation Planner Web Part  

Multilevel Tile Web Part  

Inspired Tiles Web Part  

Facebook Timeline Web Part  

Zip Creator  

Web Part Support  

Web Part Bundle  

Microsoft Sharepoint Web Parts

SQL Bullet Graph Gauge Sharepoint Web Part



SQL Bullet Graph 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 download..
SQL Bullet Graph Web Part for Sharepoint 2013
30 day Evaluation Version

Free download..
SQL Bullet Graph Web Part for Sharepoint 2016
30 day Evaluation Version

Free download..
SQL Bullet Graph Web Part License Key
per Server License
USD 125.00
Web Part Installation Instructions download..
Deployment Instructions for SP 2010 download..
SQL Bullet Graph Web Part

KPI Indicator

KPI Indicator

KPI Indicator


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.



Please enter a comment below if you have problems with the installation, want to give feedback or have suggestions for improvements:

User Comments Post a Comment 

Steve Ledridge  
2/17/2010 23:09 
can the kpi ranges be reversed ex. 0-1=green,2-5=yellow,6+=Red
Juerg  
2/18/2010 12:35 
Steve,
good point! We’ve thus now added a new “Revers KPI Indicators” option. Please just replace the DLL, followed by an “iisreset” if you placed the DLL in c:\windows\assembly.
Oliver  
5/24/2010 10:09 
Hi, what .NET framework I need to have to run your Web parts? I have SP2007 but want to migrate to SP2010. Thanks, Oliver
Juerg  
5/24/2010 13:30 
Oliver, our web parts are actually compatible with Sharepoint 2010. You will need .NET version 3.5
flemming  
5/26/2010 12:43 
unable to get this to work The actual value is ${actual} compared to our goal of ${reference} for this quarter
Juerg  
5/26/2010 13:51 
Flemming,
we actually added this feature on April 8 (Version 1.1.2) so you most probably are using an older version (which you can look up at the top of the web part’s configuration pane.
Please just re-download the current Zip file, extract and then replace the DLL (followed by an “iisreset” command if you placed the DLL in c:\windows\assembly or installed using the WSP solution).
George  
8/25/2010 16:50 
How do I connect to an excel spreadsheet to pull data? The problem I have is that Moss 2007 will not accept pictures of the bullett graphs, so instead I need another option. Thanks.
Juerg  
8/26/2010 14:07 
George,
please proceed as follows for XLSX files:

DB Connection String:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\test.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES"
Please replace c:\test.xlsx with your file path.
Also note that you might have to install the Microsoft 2007 Office System Driver Data Connectivity Components on your server.
You can download the driver from http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

SQL Query: SELECT * FROM MyRange

Just use regular SQL Syntax, where “MyRange” is a named range within a work sheet (just mark a block of cells and then assign a range name to it via the right mouse contect menu). Include the Header row as the first row of your range.
Simon Davidson  
9/20/2010 16:34 
Is it possible to have the KPI range values be passed from the SQL statement. i.e. I have a SQL statement that works out the actual income against the budget.
Juerg  
9/20/2010 17:49 
Simon,
you can select the range values as follows:

SELECT ActualValue,ReferenceValue,Lower,Upper FROM Table WHERE..

The Indicator displays
- Red if the ActualValue is below the “Lower” value
- Yellow if the ActualValue is between the “Lower” and “Upper” value
- Green if the Actual Value is above the “Upper Value”

Please note that you have to include the “ReferenceValue” (even if not needed) if you supply the “Lower” and “Upper” transition values via the SQL query.
Muzammil Hussain  
10/6/2010 22:37 
I have installed trial version and setup as per instruction: but it can only display the values in KPI Indicator, when i uncheck it it simply display 1 to 100 without any graph line, Kindly advise?????
My SQL Query is:
SELECT revenue_qtd,fulltarget,target,target FROM [Revenue_Targets] WHERE current_flag='Y'

Thank you in anticipation
Juerg  
10/7/2010 12:48 
Muzammil,
the SQL query needs to select at least one value (the actual value displays as a black bar within the graph):
SELECT ActualValue FROM ..

You can also select 2 values:
SELECT ActualValue, ReferenceValue FROM ..
(the Reference value is displayed as a red vertical line)

You can also select 4 values:
SELECT ActualValue, ReferenceValue,LowerLimit,UpperLimit FROM ..

This allows you to dynamically select the range transitions point (gray areas).

Example: SELECT 190,150,75,125 produces the below graph:


Please note that you also need to give 3 values in the “Range Values” setting (even if you override the first two by selectimg these as the 3rd and the 4th column in your SQL query.
Muzammil Hussain  
10/7/2010 22:35 
Thank you very much for the information, I need to know little more:
- Can this Gauge take the higher values like 243000000?
Also as mentioned by your example above: as I have the database table named "Revenue_Targets" which have 4 columns as follows:

1- "revenue_qtd" which contains ActualValue.
2- "target" which contains ReferenceValue.
3- "fulltarget" which contains the UpperLimit.
4- "current_flag" which contains the current active row info.

So my question is that can the following query works well:

SELECT revenue_qtd,target FROM [Revenue_Targets] WHERE current_flag='Y'

Example values in the revenue_qtd and target is as follows;
- revenue_qtd = 16000000.6604
- target = 240000000.0000

Thank you in anticipation.
Juerg  
10/8/2010 11:05 
Muazammil,
yes, your numbers are too big for the chart. If I correctly read, your target is actually 240 Millions.
You can scale down the numbers by a factor of 1000 (eg. display the numbers a “thousands”) as follows:

SELECT revenue_qtd/1000,target/1000 FROM [Revenue_Targets] WHERE current_flag='Y'
Anita  
1/26/2011 16:10 
How do I format currency to display with two decimals? The field is already formatted as a sum.
Juerg  
1/26/2011 16:30 
Anita, do you refer to the fact that the web part displays integer currency values (eg. USD 50) as $50 instead of $50.00 ?
Vignesh  
8/9/2011 20:07 
We had to give permission to each user accessing it when we deployed the dll in the bin directoty when sharepoint is running under minimal trust...Is this intentional?
Juerg  
8/10/2011 14:59 
Vignesh, we strongly recommend to deploy the DLL to c:\windows\assembly (as opposed to the BIN directory). The DLL will now get full permissing whereas when placed in the BIN folder, depends on your web.config's Trust Level (which is by default set to "WSS_Minimum" and thus does not grant the required premissions to the web part).
Andre Fernandes  
5/4/2012 21:50 
Can this web part work with a connection from a Data Connection Library instead? It would make more sense to me than feeding a connection string into each web part.
Adriano  
5/16/2012 00:12 
how I can change the number format that displays,it shows me in a format Spanish and I want American format
Daniel Pingel  
5/29/2012 15:56 
Is it possible that the KIP shows 3 Ranges?
0-17 = green, 18-24=yellow,25+=red?
Thomas  
5/29/2012 17:50 
Daniel,
check "Reverse KPI Indicators" and enter in "Range Values": 17,24
to get the desired result.
Brad  
8/8/2012 17:50 
I am getting an error message that says "Error: You must enable Web Parts by adding a WebPartManager to your page. The WebPartManager must be placed before any Web Part controls on the page" I am having no difficulties with the SQL Query View Webpart we have from you. I have attempted creating a new page for the web part, recreating a webpart zone, and adding it to the same webpart zone as the working Sql Query Viewer webpart and receive the error message each time. I am having problems with no other webparts besides this one. I am using sharepoint 2007 and it is showing AE SQL Gauge Web Part being Active under site features.
Geoff  
11/13/2012 19:32 
Is there a way to make it so that the size is done by % rather than px so that it can grow/shrink to the users resolution?
Thomas  
11/15/2012 17:06 
Geoff,
we added this feature to the actual version 1.1.13 for bullet graphs downloadable at the top of this page. Optional you can enter 6 or 7 digits into the miscellaneous configuration field "Chart width (px)". The first 2 or 3 digits set the width percentage, the remaining 4 digits are for the size in pixels which is mandatory. E.g. 100% img width and 800px chart width: "Chart width (px)" = 1000800 or e.g. 75% img width and 1200px chart width: "Chart width (px)" = 751200
Patrick  
5/24/2013 16:56 
Hi,
I'm evaluating this bullet graph to display "Service Level Objectives", the famous 99.99999.
Is there a way do display 5 numbers after the dot ?
Thank you
Juerg  
5/24/2013 19:03 
Patrick,
do you actually mean that you want to round 99.99999 to 100 ?
Patrick  
5/27/2013 14:29 
Hi Joerg,

No, in fact, I would like to use it to display the up time of services (for exemple: e-mail service uptime goal is 99.99900 and Actual uptime is 99.99876 --> yelow triangle)

So, it wold be grat if I could diplay 4 or 5 digits after the coma/dot without beeing rounded.

mfg

Patrick
Juerg  
5/27/2013 15:44 
Patrick,
we have now added the new "Label Value Precision" web part setting to allow you to specify the number of decimal places for the KPI label values.

Example
:
Labels formatted to 5 decimal places

Please re-download the updated Zip file , extract the WSP file and then update the web part solution.
qudsia  
8/26/2013 20:12 
Hi,
I have sharepoint list where I am displaying the following columns:

salesRep indTarget Sales
Nina 10 40
Mina 20 30

For actual value I am using Sales and for reference I am using indTarget. When I enter the values I get sum of indTarget for all sales rep although I want the reference to be their indTarget. Sales is displaying fine.
Eg the caption would read the actual value is 40 compared to our goal of 30 ( which should be 10 or 20 depending on the sales rep).
Thanks.
Juerg  
9/3/2013 12:57 
qudsia,
is it correct that you would like to display the Graph (or KPI) for a specific sales rep (as opposed to sum up all the columns) ?
Natasha  
10/9/2013 19:54 
Hi,

I'm testing out this web part, particular the tile option. My values show with two decimal places by default. Is there a way to remove the decimals or format the number for the tiles?

Thanks.
Juerg  
10/10/2013 19:53 
Natasha,
we have now fixed the problem with showing the values always using two decimal places when using the "Tile" option which now respects the web part's "Label Value Precision" setting.
Please re-download the updated Zip file, extract the WSP file and then update the solution.
Zach  
12/4/2013 20:21 
Is it possible to display the KPI Indicator using metrics of percentage. Goal, 100%, actual 98%. And then allow the green, yellow, red to be displayed based upon the percent achieved. As an example, 90% -> 100%, Green, 70% -> 90%, Yellow, below 70% Red.
Juerg  
12/10/2013 17:18 
Zach,
would you provide the Goal, Actual and Range values as percent values (eg. the web part just would format the nummbers as percentages) or would you expect the web part to convert the data dynamically (based on the Goal value which would represent 100%) ?
Zach  
12/13/2013 23:52 
I would provide the actual % values, no need for them to be calculated. I would like a way to provide a number, and a unit of measure. As an example, display goal of 98% and actual of 95% ... or perhaps a goal of 120 seconds, and an actual of 110 seconds. I wouldn't need any calculation, just display of my values and a reference/UOM.
Juerg  
12/16/2013 11:44 
Zach,
we have now added the new "KPI Unit Of Measure" web part setting that allows you to enter to unit o mesaure to be appended to the KPI values displayed by the web part.
Please re-download the updated Zip file, extract the WSP file and then update the solution.
Michael  
1/30/2014 02:38 
Hi, We are using the Gauge display option and wondering if there is any way we can change the colour of the text within? In the example image you have on this page, we would like to change the colour of the text "Open Tickets" and also the number "190". Have taken a look and it seems to be using a text attribute fill - which i've been unable to override. Is it possible to get it changed to use css?
Thanks!
Juerg  
1/30/2014 12:28 
Michael,
we have now added the new „titlecolor“ and „valuecolor“ options to customize the colors of both the gauge title and the gauge value.

Example (enter the below into the web part’s “Options” setting)
titlecolor=red|valuecolor=green

Please re-download the updated Zip file, extract and then update the web part solution.
Marc  
3/18/2014 14:22 
Has anyone tried adding a 4 and 5th Range color. We would like to show the tile grey when the value is 0 and show it blue when its passed the goal value. Is this possible?
Juerg  
3/25/2014 15:15 
Marc,
you actually can control the tile color used when the value is equal or above the goal by entering the corresponding colors into the web part’s “Range Colors” setting:

Example:
ee0000,ffcc33,00cc00

- the first color value (red) will be displayed if the value is below the “lower” limit
- the second color value (yellow) will be displayed if the value is between the “lower” limit and the “upper/goal” value
- the third color value (green) will be displayed if the value is above the “upper/goal” limit

We now have added the option to add a fourth color value to the “Range Colors” setting. If present this color will be used if the value is zero.

Example:
ee0000,ffcc33,00cc00,a0a0a0

Please re-download the updated Zip file, extract and then update the web part solution.
Mark B  
11/6/2014 23:44 
Hi, Can we pass additional fields from the sql select query and reference them in the chart caption. eg. either reference the lower and upper limits or additional 5th, 6th...... values returned by the sql query. This would be handy as we would like to display for example outstanding work that hasn't been billed.
Juerg  
11/7/2014 13:52 
Mark,
you actually can refer to the columns returned by the SQL Query in the “Chart Caption” setting using the “{columnname}” token.

Example:
SQL Query:
SELECT 7000,10000,3500,6500,8000,'Year 2013' AS Custom,'Reuters' AS Provider

Chart Caption:
Actual value=<b>${actual}</b><br>
Donated: <b>${actual}</b><br>
Goal: <b>${goal}</b> ({percent})<br>
Custom: <b>{Custom}</b><br>
Provider: <b>{Provider}</b></span>


Result:
Actual value=$7,000.00000
Donated: $7,000.00000
Goal: $6,500.00000 (70 %)
Custom: Year 2013
Provider: Reuters
Ted  
3/5/2015 05:31 
hi, is it possible to redirect to a webpage or open a excel when click the web part, either caption or the graph. thanks
Chris,  
3/9/2015 10:59 
How to configure the Metro tile to get the same results as the top of this page.
I tried Gauge, KPI and Bullet, they work fine, but once I change to Tite, the number doesn't show up.
Thanks.
Juerg  
3/9/2015 14:58 
Ted,
you would need to manually embed the link into the caption using HTML as shown in the below example:

This is the caption.<br>
Open the
<a href="http://someurl">corresponding page</a>
Juerg  
3/9/2015 15:09 
Chris,
the Metro Tile expects the below values:

Example:
SELECT 7500 AS Actual,9000 AS Reference,4000 AS Lower,7000 AS Goal

(eg. the KPI value is the ratio of the actual vs. the reference value).
Chris  
3/9/2015 15:28 
Hi, Juerg,
I copied the sql statement, it still doesn't work. It shows only the box with caption but no number.

I have another problem with KPI Gauge Type. I have a KPI which goal is <= 7 days. 1 is good and satisfactory is 7 and >8 is bad.
Here is the setting:
Reference = 7
Lower = 0
Upper = 7
I enabled the Reverse KPI Indicators.
While the Actual is <= 6, the indicator is GREEN, it's correct. However, if Actual is 7, is is RED. It supposed to be ORANGE for satisfactory.
Please adv.
Thanks
Chris  
3/11/2015 07:14 
Hi,
please ignore my question.
It has been fixed.
I set Label Value Precision to zero, and lower and upper to 7.01. Then it shows GREEN when actual is 7.
Thanks
Ky  
4/16/2015 08:38 
Juerg, how do I configure my reverse KPI to show 2 Range.
This is meant to keep track of "Loss Time Injuries".
0 is green, and anything above 0 is red.
Juerg  
4/20/2015 19:55 
Ky,
please enter the below values into the web part’s “Range Values”:

1,1

assuming that your SQL SELECT statement just returns a single value (“Loss Time Injuries”).
Chris C  
4/21/2015 01:01 
Is there a way to configure this web part to use Excel Services to read an Excel file stored in SP document library? If so, please post an example of the connection sting (or method used to connect to Excel Svcs). Thank you.
Juerg  
4/21/2015 16:15 
Chris C,
we have now added support for referring to an Excel file stored in a Sharepoint document library.
Please use the below connection string in this case:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=http://somedomainl/somesite/somelibrary/somefile.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";

The web part by default creates a local copy of the Excel file on the web front end server in the root of the C: drive.
To specify a different location, please enter the below into the web part's "Options" setting:

temp=c:\somepath

(replace "c:\somepath" by the desired file location).

Please download the updated web part, extract the WSP file and then update the web part solution.web part solution.
Chris C  
4/21/2015 19:57 
Fantastic news! I will test this tomorrow. Quick question, will the web part pickup changes to the file on an interval or any time the page it is contained on is rendered? Thanks!
Juerg  
4/21/2015 20:37 
Chris,
the web part will recreate the file on each page visit.
Chris C  
4/27/2015 19:05 
I really appreciate the changes! Unfortunately we are running SP in 64-bit, so we cannot access the Microsoft.ACE.OLEDB.12 data provider.
Juerg  
4/27/2015 19:17 
Chris,
in this case we recommend to install the Microsoft Access Database Engine 2010 on the server:
http://www.microsoft.com/downloads/details.aspx?FamilyID=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en
Chris C  
4/27/2015 20:08 
Disregard my previous comment, I found a 64-bit driver. For a long time it didn't exist. For those in need: http://www.microsoft.com/en-us/download/details.aspx?id=13255


Chris C  
4/27/2015 21:48 
Thank you! It's working now, just fiddling with the formatting and other options. Cheers.
Scott  
5/19/2015 17:30 
I'd like to be able to set the gauge indexes from a custom set of numbers such as: [ 70 to 110 ] with Range Values at [ 80, 90, 100 ]. At the moment it appears that all gauges and bullet graphs will start at 0 and go to the maximum specified. Is there any way to change this default behavior?
Adam Cassel  
10/30/2015 13:19 
Are there any plans to make this fantastic webpart compatible with SharePoint Online (Office 365)?
Juerg  
10/30/2015 14:07 
Adam,
this is unfortunately not feasible, since Sharpoint Online does not allow a web part to connect to a database located outside of Sharepoint Online.
Sukotto  
1/20/2016 17:34 
Hello, I've two questions for you:
1. Is it possible to have the range as a negative percent to positive percent? (e.g. -10,0,10)
2. Is it possible to calculate the KPI value as the percent difference between Actual and Reference(Goal) -- not just ratio -- like the following:
((Actual - Reference) / Reference) x 100

These are important for our KPI which would, ideally, be a measure of how much our actual values differ from expected values and tend to fall in ranges of around +/-4%
i.e. a range of:
Red=-10% ~ -2%;
Yellow=-2% ~ +2%;
Green = +2% - +10% is desired

Thank you!

Technical Support Contact Information
If you find that you cannot resolve an issue using the above tools, our Technical Support staff will be ready to handle your technical support needs. You can reach our staff by phone or by email.

Phone: +41 (0)62 823 75 75 (9am - 5pm GMT)
Fax : +41 (0)62 823 75 74
Email: support@amrein.com
 
© 2017 AMREIN ENGINEERING AG


No place like Amrein! Best Webparts, great prices, and even better customer service!

Yaniv Kesner, ServIT LTD





Subscribe to Newsletter
If you want to be kept informed about our new or enhanced Sharepoint web parts, subscribe to our Sharepoint Web Part Newsletter:

You can also subscribe to our Web Part News RSS Feed:

RSS Feed

Follow us on Twitter:

Web Part NewsSharePoint News Carousel Web Part
5/1/2017
The new "News Carousel" Web Part allows to rotate SharePoint List items (typically used with a SharePoint "Announcements" list) manually and/or automatically. It displays an optional image, the title and the item body text. The web part can be used with SharePoint 2010, SharePoint 2013 and SharePoint 2016.

SharePoint List Rotator Web Part
5/1/2017
The new "List Rotator" Web Part allows to rotate SharePoint List items manually and/or automatically using a freely configurable layout template. The web part can be used on SharePoint 2010, SharePoint 2013 and SharePoint 2016.

SharePoint Facebook Timeline
6/1/2016
The free "Facebook Timeline" Web Part allows to embed the Timeline of the specified Facebook timeline. The users can like and share the posts without having to leave SharePoint.

The web part can be used on SharePoint 2010, SharePoint 2013, SharePoint 2016 and SharePoint Online/Office365.

SharePoint Toast Notifcations
6/1/2016
The Toast Notification SharePoint solution lets you centrally manage notifications and alerts targeted to all users or specific user groups.
It reads entries from the included SharePoint List and displays notifications targeted to either selected groups or all users during the specified time window as configured for each notification.
The solution can be used on SharePoint 2010, SharePoint 2013, SharePoint 2016 and SharePoint Online/Office365.

Bullet Graph Web Part Basic Annual Support
Basic technical support provides up to 4 incidents per year (1 business day response time) plus free service packs.
Price: USD 75.00