XLReport allows to define Parameters to Queries.

So; every time a real-time data set is inserted into Excel the user will be asked to assign a parameter. This can also be useful for creating dashboards using the same query with different parameters. Once the data was inserted into Excel you can work with it as usual like creating further calculations and of course also binding charts to it.

Now; whenever you click the “Refresh” button, XLReport will retrieve the most current live data and update the Excel sheet.

See also these videos:

Learn more about XLReport Parameter Queries