Learn How to use XLReport for Easy Real Time Excel Reporting

Video Tutorials

videoXLReport - Getting Started | 04:20

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.


Queries

videoThe Power of the XLReport Query | 04:30

There is practically no limitation to building your queries with the XLReport Visual Query Builder.


videoCreate a Query from an existing Query | 01:30

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.


videoParameter Queries | 01:10

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.


videoRefresh Parameters | 01:10

Click "Refresh Parameters" to retreive parameterized real-time data.


videoDate Filters | 01:10

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.


videoEdit a Query and Save it as a new one | 01:10

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.


Insert Data into Excel

videoInsert External Data into Excel | 02:30

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.


videoRefresh Fields | 01:40

If you change some query definition and fields you can easily update your existing XLReport objects.


videoApply Parameters and Refresh Data | 02:10

Easily apply user input parameters and refresh the data to retrieve the most recent data set.