Archive for the ‘How-to’ Category
Sunday, December 21st, 2008
Buttons on Dashboards can be used to take certain actions. InfoCaptor dashboard buttons can be set to take a database action or a non-database action.
In case of a database action you can call a database stored procedure
Goto Menu Create -> Parameter
Leave the Parameter Name blank (Optionally- If you need have ...
Posted in How-to | No Comments »
Sunday, December 21st, 2008
Automatic refresh of dashboard view is useful in following scenarios
Database monitoring
Lot of database activity is stored real time in logging and statistics table. It is possible to create dashboard purely using SQL queries against these performance tables. Once the dashboard is created, you could set it on automatic refresh ...
Posted in How-to | No Comments »
Sunday, December 21st, 2008
Sticky Notes: Sometimes it is useful to pass some information in the means of plain text on the dashboard. Sticky notes can be created by selecting 'STATIC' type in the Datatype field of the parameters
Goto Create --> Parameter, select 'STATIC' for the DataType. Enter the static text in the text ...
Posted in How-to | 2 Comments »
Monday, December 1st, 2008
This tip demonstrates how to create custom number format and percent format for the number axis (also known as the range axis in jfreechart)
In order to get the Item labels display a percent value, Edit the chart property "Item Label Number Format" to "##0%" and in order to display percent ...
Posted in Charts, How-to | No Comments »
Tuesday, November 25th, 2008
How to add custom background images to your dashboard charts.
In this example we placed this image as background for the thermometer chart http://www.foreststreams.com/snowcreekwater3web.JPG
import org.jfree.chart.plot.ThermometerPlot;
import org.jfree.chart.JFreeChart;
import java.awt.Toolkit;
import java.awt.Color;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import java.awt.event.KeyEvent;
import java.io.File;
import java.io.IOException;
import java.net.URL;
import javax.imageio.ImageIO;
import java.awt.image.BufferedImage;
ThermometerPlot plot = (ThermometerPlot)chart.getPlot();
// plot.setInsets(new RectangleInsets(5.0, 5.0, 5.0, 5.0));
plot.setThermometerStroke(new BasicStroke(2.0f));
plot.setThermometerPaint(Color.lightGray);
plot.setUnits(ThermometerPlot.UNITS_NONE);
plot.setRange(50000.0,200000.0);
float h = displayFrame.getHeight();
float w = displayFrame.getWidth();
// ...
Posted in Charts, How-to | 1 Comment »
Tuesday, November 25th, 2008
Interval Marker is a special feature that allows you set targets or reference point for your bar or line charts.
Here is a basic bar chart
To add a reference line or interval marker as below
Use the following code for the javascript
//import the necessary classes
import org.jfree.*;
import org.jfree.chart.axis.CategoryAxis;
//import org.jfree.chart.axis.CategoryLabelPositions;
import org.jfree.chart.axis.NumberAxis;
//import org.jfree.chart.labels.CategoryItemLabelGenerator;
//import org.jfree.chart.labels.StandardCategoryItemLabelGenerator;
import org.jfree.chart.plot.CategoryPlot;
import ...
Posted in Charts, How-to | No Comments »
Tuesday, November 25th, 2008
How to add a constant horizontal line or a control line.
Following is a simple line chart
The query for the above chart is as follows
select calendar_month_name, sum(quantity_sold)-3500 as qty_sold
from [detail_data$]
where fiscal_year = 2001
and country_region like 'Americas'
group by calendar_month_name
Now if we need to add a Target line which would be a constant ...
Posted in Charts, How-to | 1 Comment »
Monday, November 24th, 2008
How to query Excel files using ODBC - JDBC?
Summary :
Why use square brackets for SQL against Excel?
How to access range of cells from Excel?
How to use un-named range of cells?
This topic is covered in various tutorial for InfoCaptor. These following snippets are taken directly from Microsoft website as easy ...
Posted in Excel, How-to | No Comments »
Monday, November 17th, 2008
A new Date Type parameter is introduced to simplify Dashboard creation and query.
When you define the Date Parameter you can specify the desired format
Select 'DATE' from the drop down list for DataType and specify your own Date Format.
When you create the date parameter with the above defaults it appears as ...
Posted in Excel, How-to | No Comments »
Saturday, September 20th, 2008
If you are trying to use SQLserver with InfoCaptor and are using the SQL Studio Express 2005 then you might encounter connection refused error
Please try the following setup before attempting to connect
open the Configuration ManagerStart -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager
2. Then at ...
Posted in How-to, SQL Server | 1 Comment »
