Product How-To: Designing Report Parameters

Designing report parameters is easy with InetSoft's reporting software and it's robust tool set. View the example below to learn more about the Style Intelligence solution.

In the example that follows, you will create a parameter sheet that prompts the user for a list of products. First, you will need to create a new report that uses parameter prompting. Follow the steps below:

1. Click the Design tab in the Portal, and select ‘Report’. This opens the Report Wizard screen.
2. Click the ‘Table Wizard’ link to create a new report. (See New Report Wizards for more information about creating reports.)
3. On the ‘Select a data source’ screen, select the ‘Order Details’ query from the ‘Orders’ node. Click ‘Next.’
4. Click ‘Next’ on each subsequent screen until you reach the ‘Filtering conditions’ screen.
5. On the ‘Filtering conditions’ screen, enter “[Product] [is] [one of]” for the beginning of the condition.
6. Select the ‘Parameter’ checkbox, and enter “product” in the ‘Label’ field. This will be the parameter name.
7. Enable the ‘Use Selection List’ option. (This provides a selection list when default prompting is used.)
8. Click ‘Append’ to add the condition to the table. (See Filtering for full information on adding conditions.)
9. Click ‘Finish’. This closes the Wizard, and loads the new report. Because the report’s table uses a parameter (“product”), the report automatically displays the default parameter input screen.
10. In the ‘product’ menu of the input screen, make a selection, and then click ‘OK’. This loads the report with only the selected products shown in the table.
11. Click the ‘Save Report As’ button on the Ad Hoc toolbar, and name the report “Parameter Sheet Report”. Select ‘Save as Template’, and click ‘OK’.

You have now created a report called “Parameter Sheet Report” that has a single parameter called “product”. When a user launches this report, they will be automatically prompted for the parameter value.

More Articles About Reporting

Ability to Do Ad Hoc Reports - Ad hoc reporting is an essential feature for business end users, providing the ability to create reports on demand without relying on predefined templates or waiting for IT support. This capability empowers users to access and analyze data quickly, leading to more informed decision-making and greater agility. Here are several reasons why business end users need the ability to do ad hoc reports: 1. Enhanced Decision-Making Business environments are dynamic, requiring rapid and informed decision-making. Ad hoc reporting enables end users to generate specific reports tailored to their immediate needs, rather than relying on static, predefined reports. This flexibility allows users...

Creating Reports for Data in SQL Server - InetSoft is recognized as a robust business intelligence and reporting solution that offers various features making it a good option for creating reports for data in SQL Server. Here are some key aspects that contribute to InetSoft's appeal in this context: Intuitive Drag-and-Drop Interface: InetSoft provides an intuitive drag-and-drop interface for report creation. This makes it easy for users, even those without extensive technical expertise, to design and customize reports using data from SQL Server databases. Connectivity to Multiple Data Sources: InetSoft supports connectivity to various data sources, including SQL Server databases. This flexibility allows users to seamlessly integrate and retrieve data from their SQL Server environments for report generation...

Evaluate InetSoft's Solution for Creating Online Visual Reports - Looking for software to create nice online visual reports? InetSoft's pioneering dashboard reporting application produces great-looking web-based dashboards with an easy-to-use drag-and-drop designer. View a demo and try interactive examples...

InetSoft's Embedding Dashboarding Tools - Embedding dashboarding tools allows application developers to provide self-service oriented graphical views of the data their application manages in the same place a where the application's users work. The instructional example below illustrates this capability of the Style Intelligence solution...

Monthly Business Dashboard Example - As your business grows, so does your need for monthly dashboards that will automate business monitoring and management. Better sales numbers, more salespeople, more clients and accounts to manage also means more products to ship and track, more employee information to file, and more variables to react to. That's why InetSoft designed the easy to use dashboard software, Style Intelligence. In addition to web-based interactive dashboards, Style Intelligence also contains a powerful reporting engine that readily meets the needs of companies of any size...