Once you launch Infocaptor, you can click on the connect button.
In this example we are using the northwind sample database
Click on connect
Once connected it will open the Option wizard
Since there is no dashboard open, the "Build New Query" is disabled.
Click on the "New Blank Dashboard"
Enter some name for the dashboard "Northwind Dashboard"
This Action immediately launches the Query Builder interface
Expand the node on the left
This displays a list of available tables
Double click on any table and it brings the table in the Query Builder window
You can now select columns and join then
To create joins, just drag the mouse on a column in the orders table. Once you see the join link appear you may release the mouse button. Now go to the second table and click on the column to which it needs to be joined.
Click on the SQL tab and you can see the SQL query that is automatically built for you
Now click on the "Create Table" button
This action creates a Qlet and places it in the dashboard
You can now right click on any column and create a drop down parameter
The parameter now automatically refreshes the qlet when you change the value