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 …
Continue reading →
Get the latest Test version at http://www.infocaptor.com/test/infocaptor_setup.exe Current version is at 3.3.10 and includes the following enhancements PDF and HTML reporting of charts (powerful reporting engine - combine Text and graphs during your PDF export) Logos on dashboard (image objects …
Continue reading →
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 …
Continue reading →
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 …
Continue reading →
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 …
Continue reading →
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. …
Continue reading →
There has been a lot of changes here at InfoCaptor website. Recently we have had lot of problems with our web host provider (lonex). We repeatedly got over CPU utilization notifications. We kept buying more and more of CPU limits …
Continue reading →