InetSoft Product Information: Reporting Software - Ad Hoc Reporting Columns

InetSoft's reporting software features customizable data columns that can be set to display complex data in a simple format. View the example below to learn more about the Style Intelligence solution.

An expression column is a custom formula that generates a new column based on the values in other fields. You can use any valid JavaScript syntax within an expression.

To create an expression column, follow the steps below:

1. Launch any one of the Ad Hoc Wizards. In Step 1, select the desired data source.

2. Proceed to Step 2 of the Wizard. Note the ‘Create Expression Column’ link at bottom.

3. Click the ‘Create Expression Column’ link. This opens the Formula Editor.

4. In the ‘Name’ field, enter a name for the new column.

5. Select the ‘Return Data Type’, which is the type of data the new column contains.

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.

 

 

 

 

 

6. In the Formula Editor, select the ‘sql’ checkbox to enter the formula using SQL syntax. Leave the box unchecked to use JavaScript syntax.

7. Construct the desired formula using appropriate operators (SQL or JavaScript). To add a field name to the formula, click the desired name in the ‘Fields’ list.

For example, you can specify an SQL formula such as

field ['Price'] * field['Discount'] with return data type ‘Double’.

You can specify a JavaScript formula such as the following with return data type ‘String’:

if (field['Discount'] > 0) { 'Yes'; // return Yes } else { 'No'; // return No }

Previous: Ad Hoc Reporting Tables

Next: Reporting Software Data Wizard

InetSoft Viewpoint

"We typically have two types of customers. The first type is the enterprise customer. They tend to be larger organizations, but they don’t necessarily have to be a Fortune 500 company, even though our customer base has 25% of the Fortune 500 companies in it. We have IBM, GE, Goldman Sachs; our customer base goes across all industries. But typically those customers would have strong data needs. They typically have a fairly experienced team that can handle BI tools and work with data models. So that is the enterprise customer. On the other hand we have OEM partners. Those are the people who build our business intelligence software into their software. Their software will typically be vertically oriented or address a particular business application. In this group, it also very diverse. They can be small software companies or startups, and they need a strong BI platform to support them. It can also be a very large organization such as GE Healthcare with whom we are going into some very large healthcare organizations. Their installations typically take months and costs millions of dollars, and we’re a part of that BI solution. Our BI product line is very flexible which can serve anywhere from small and medium-sized company all the way to multinationals." - Luke Liang, CEO, InetSoft

 

 

 

 

 

 

 

 

 

 

 

 

 

More Resources:

		InetSoft Documentation: Data Tablesl
		Java Reporting Tools from InetSoft
		Award Winning Java Reporting Software
		A Reporting and Business Intelligence Platform