canned reports Archives - Helical Insight

Values/Keywords that are restricted to pass in canned report parameter filter expression

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

Canned Report, canned report parameter filter expression, canned reporting, canned reports

Share with

Adding A Dynamic Parameter To Canned Report

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

Adding A Dynamic Parameter To Canned Report, Canned Report, canned reporting, canned reports, Dynamic Parameter, helical insight

Share with

Replacing Null Values With Blank In Canned Report

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

Canned Report, canned reporting, canned reports, Replacing Null Values With Blank In Canned Report

Share with

Customise Size Of Paper For Canned Report

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

canned reporting, canned reports, Customise Size Of Paper For Canned Report, Helical Canned Reports

Share with

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