![]() |
Interactive Reporting |
|
With Interactive Reporting you can generate any report you need on demand. Whether inside of Excel or outside the Excel environment, all you need to do is specify the settings required for the report, click the Generate Report button and voila, the report is generated and presented to you. It’s that easy! You use interactive reporting any time you need a report that requires specific input from a user before it can be generated. This report can be used over and over again, giving your users the immediate information they require in one simple to use tool. Interactive reporting is designed primarily for use with historical and relational data sources. There are 2 basic steps to setting up an interactive report: configuring the query to retrieve the report data and designing the interactive form. When you configure the query (or history group) to retrieve data for the report, use a variable for any condition you want the user to supply when the report is generated.
Once you have completed the query, you can now design the interactive form. In the Interactive Designer, you can configure prompts for all the variables contained in the query. In addition, you must define all the commands necessary to generate the entire report.
The report can now be generated both from within Excel and from outside. Within Excel you can use the Worksheet Interactive option to open the interactive form. Simply specify the parameters and click Generate Report. A new report will now be generated based on your settings. From outside Excel you can launch the XLRiDisplay program. This contains a list of all the available Interactive Reports. Simply select the report, specify the parameters and click Generate Report. A complete report will be generated and presented to you. This can be launched from the command line or from your application.
© 2006 SyTech, Inc. All Rights Reserved. |
|