How-to
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 | No Comments »
Download the zip file from this location http://www.infocaptor.com/files/setup/infocaptor_server_files.zip
Extract the infocaptor_server.jar file in a directory and then depending on the platform type the following command from command line.
java -jar infocaptor_server.jar
Posted in How-to | No Comments »
To create this chart, your SQL should return only one column and one row
select sum(quantity_sold) as qty_sold
from [detail_data$]
where fiscal_year = 2001
and country_region like 'Americas'
(Complete Steps) Create Thermometers in Dashboard
Tags: thermometer chart, dashboard thermometer, dashboard gauges, jfreechart thermometer
Posted in Charts, How-to | No Comments »
The basic requirement for a line chart is same as the bar chart. You need minimum of two columns, if you add more than two columns then it adds another line in the same chart corresponding to the numeric column
select job_type,
max_salary as VAL ,
min_salary as SVAL
from job_table
(Complete Steps) Create Line ...
Posted in Charts, How-to | No Comments »
This is an alternative to the meter chart
The requirement is the same as meter chart, your SQL should return only one column and one row, just a single cell value
(Complete Steps) Create Dashboard Dials
Tags: dashboard gauges, dashboard dials, dashboard charts, speedometer chart, dial chart, meter chart
Posted in Charts, How-to | No Comments »
To create this chart, your SQL should return only one column and one row
(Complete Steps) Create Dashboard Gauges
Posted in Charts, How-to | No Comments »
In order to create a Pie Chart, your SQL should return two columns as shown below
select account , sum(amount) as Expense
from
[qb_data$]
where "Account Type" = 'Expense'
and date between #10/1/2007# and #05/23/2008#
and class like '%'
group by account
(complete steps) Create Pie Chart for Dashboard
Posted in Charts, How-to | No Comments »
The basic requirement is that the SQL query should return three columns
for e.g.
select Format(date,'YYMM') & ' - '& Format(date,'MMM') as Month , switch(class is null,'Unknown Class',class is not null,class) as class_type, sum(amount) as Expense
from
[qb_data$]
where "Account Type" = 'Expense'
and date between #10/1/2007# and #05/23/2008#
and class like '%'
group by Format(date,'YYMM') & ' ...
Posted in Charts, How-to | No Comments »
The basic requirement is that the SQL query should return three columns
for e.g.
select Format(date,'YYMM') & ' - '& Format(date,'MMM') as Month , switch(class is null,'Unknown Class',class is not null,class) as class_type, sum(amount) as Expense
from
[qb_data$]
where "Account Type" = 'Expense'
and date between #10/1/2007# and #05/23/2008#
and class like '%'
group by Format(date,'YYMM') & ' ...
Posted in Charts, How-to | No Comments »
A Bar Chart needs a minimum of two columns. The first column is the character based column (it could be a numeric but it forms the Axis column either X or Y). The second column is the numeric value column which represents the bars in the chart
NOTE: You can have ...
Posted in Charts, How-to | No Comments »
