Example of a query using SQL extensions to show a pop up window to get information from the user to complete a SQL statement
Sample Grid Results. Very power grid!
Grid Results, showing the results of dragging the City field to the grouping area and then adding a counter to the grouping footer
Grid showing the results of a lightning fast string search. Note that it searches all fields in the results!
You are able to highlight rows/cells based on various values. This one was asked to highlight based on the City name being Calgary.
Form showing Graphing options for the data from the Grid. Simple pick your columns, what rows you want to graph, how you want it to appear and it does...
Sample quick chart from the data in the Grid. You have a huge amount of control over the appearance of this grid, including what type (Bar, Pie, etc.), colors, title, legend, etc.
Simple pivot grid of drug prescriptions by patient sex. All created via drag and drop of fields. Note that the chart at the bottom was created simply by selecting some cells. Powerful, yet very easy to use!
End User Report Designer. Use drag and drop to create your reports and WOW those who need your data!
Export the Grid data to a spreadsheet form built into the application (do not need Excel!) and use all your favorite features (formulas, tables, pivots, charts, etc). It can also save to and load from Excel files!
InSights comes with a Visual Query Builder. This allows you to visually build your queries to make writing SQL faster and easier!
Export the data in your Grid to multiple formats. CVS, Text, HTML, PDF, Excel, etc.
Export your Chart images to a multitude of formats - everything from PDF to image files!
Export your reports to a wide variety of data formats - including Excel and PDF.