Learn How to use XLReport for Easy Real Time Excel Reporting
This short XL Report - Getting Started - video will show you the most important steps to connect to your external data-sources, create queries and insert real-time data into Excel.
There is practically no limitation to building your queries with the XLReport Visual Query Builder.
Besides building queries from your database tables and views, XLReport also allows designing queries from already existing XLReport Queries. It also combines XLReport Queries with database tables and views.
Define parameterized queries so when you run it, it prompts for criteria to use. You select the records for the result set so that the same query can be used to retrieve different result sets.
Click "Refresh Parameters" to retreive parameterized real-time data.
Sometime it is useful to apply a Date Filter like "Current Month", "Last Year" or "Last Quarter" to a Query. Once a Date Filter was applied it will always show only the values set by the filter.
Sometimes you just need to do small changes to an existing XLReport Query and save it as a new one. Instead of building the Query from scratch you can edit an existing Query and save it with a new name.
The whole purpose of XLReport is to insert external live connected data into Excel Select the XLReport Query object from within the Project Explorer and insert its underlying data as Static Sheet, Real Time Sheet Live or Real Time Pivot Table.
If you change some query definition and fields you can easily update your existing XLReport objects.
Easily apply user input parameters and refresh the data to retrieve the most recent data set.