InetSoft Product Information: Reporting Software - Ad Hoc Reporting Tables

InetSoft's reporting software features embeddable tables that allow you to sift throuh complex data at a glance. View the example below to learn more about the Style Intelligence solution.

A table is a standard element used in most reports to display data. You can also group the data, and calculate subtotals and grand totals. There are also Crosstab and Section Wizards which provide similar results. Learn the difference between these three and understand when to use each.

To create a report using the Table Wizard, follow the steps below:

1. Choose ‘Table Wizard’. In Step 1, select ‘Order details’ within ‘Orders’. Click ‘Next’ to proceed.

2. In Step 2, you can select detail columns. By default, all the columns from the query are automatically selected. For this example, remove them all. Note that you can also derive new columns from existing columns.

3. In Step 3, group by ‘Company’ and ‘Product’.

View a five-minute Flash demo to get an overview of what InetSoft's business intelligence software, Style Intelligence, can do and how easy it is to use.

 

 

 

 

 

 

4. In Step 4, select ‘Total’ as a Summary Column and set ‘Sum’ as the aggregation function.

5. In Step 5, add a condition for “Discount is greater than 0,” and click ‘Append’ to insert the condition.

6. In Step 6, you can add a ranking condition to groups which have been summarized. Rank the Top 5 Customers by Sum(Total).

7. Click ‘Finish’.

Previous: Ad Hoc Reporting Charts

Next: Ad Hoc Reporting Columns

InetSoft Viewpoint

"Why this enterprise mashup capability is so critical is because we have learned the business processes are all very dynamic. You have most of them set up so you can have a consistency. But nonetheless, problems arise when you have exceptions – a new product is added, a new supplier comes on line, et cetera. Those things happen all the time. But in this scenario, you still would like to get that consistent execution. You probably need to bring additional information into the picture, or have more than one business process come together to address the problem. So we have observed our users to use this capability of data mashup to really utilize all of their data sources and dynamically manipulate them and transform them to address new needs. They can answer the business questions they have on hand to keep their business process consistent, executing the way they envisioned. The context provided by the business process is right. It’s where operational business intelligence lives. It’s just that this context can be quite different for different customers. We are talking about very formal BPM deployment supported by particular technologies. Some of them really mashup a set of existing applications, and they are reinventing them for new purposes." - Luke Liang, CEO, InetSoft

 

 

 

 

 

 

 

 

 

 

 

 

 

More Resources:

		The Real Time Reporting Solution from InetSoft
		Java-based Reporting Tools
		Award Winning Java Reporting Software from InetSoft
		Getting Interactive Reporting from a Business Intelligence Platform