helical insight Archives - Helical Insight

Usage of Field Calculations

In canned reports module, there is the option of using calculated fields. The calculations options are available on right click on any component (text or numeric field) on the canvas. In order to apply the calculation on a field, right click on the field, hover to Calculation option and select the calculation you want to

canned reports, helical insight

Share with

Helical Canned Reports: When to Use

Helical Insight 4.0 onwards we provide various methods of reports creation which includes Adhoc Interface, Community Report and Canned Report interface. In this blog we are going to explain when it is ideal to use Canned Reporting interface. If your requirement is more on the data visualization and dashboard then Adhoc interface as well as

BI tool, canned reports, helical insight

Share with

Implementing Data Security In Canned Reports Based On Logged In Organization

Introduction:In this blog we are going to explain how to implement data security based on the logged-in organization. We have created sample tabular report having the data of client wise meeting date. In this example covered below, we want to filter the data based on the organization that the user belongs to. Organization for default

canned reports, data security, helical insight, open source

Share with

Creating Canned Reports with ALL as default value in Input Parameters

In this blog we shall see how to create canned reports with ALL as default value in input parameters. STEP 1: Create a connection To know more about the types of datasource connections that can be established, refer to the blog. STEP 2: Write a query without using parameter/where clause After providing the connection details

canned reports, data security, helical insight, open source

Share with

Creating Canned Reports with Multi-Select Input Parameters

In this blog we shall see how to create canned reports with multi select input parameters. STEP 1: Create a connection To know more about the types of datasource connections that can be established, refer to the blog. STEP 2: Write a query without using parameter/where clause After providing the connection details in the previous

canned reports, data security, helical insight, open source