In helicalinsight few values are restricted in filter expression for the security reasons. If you pass that restricted keyword you might get the below error Error: HCRException: The filter value is unaccepted, please try with someother value. In case if you compulsory want those values to be passed in filter expression then navigate yourself to
Read More
In this article we will see how we can create a dynamic parameter for canned reports.This document has been created for Helical Insight version 4.1 GA. A parameter is a variable that takes the value passed by the user and hence the data gets filtered before it is displayed on your screen. A parameter can
Read More
This article shows different ways in which we can replace Null values by blank. One in the query, second in Text field properties and third in the Typography box by using Javascript. In the datasource page, we can use COALESCE function to replace NULL values with the required value. Second way is to Check the
Read More
In Helical Insight 4.0 version, for creating any canned report, the first requirement is to set the size of paper or canvas on which the report is to be designed. By default when you click on empty space on canvas, there will be standard paper sizes in the Page Setup Section. All the sizes are
Read More
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
Read More
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
Read More
Introduction: In this blog we are going to explain how to implement data security based on the logged-in user name. We have created sample tabular report having the data of client wise meeting date. In this example covered in the blog, we want to filter the data based on the user name of the user who
Read More
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
Read More
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
Read More
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
Read More