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
After release Helical Insight 4.1 GA, there were many more functionalities which were expected by end customers on the canned reporting module for which custom patches were deployed. In this blog we are going to cover about those custom patches and using them as well as what does that custom patch do. 1. Excel continuously
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 this blog, we will see how to display selected filter values at the top of report in Helical Insight. This is more specifically useful when we have drill down from another report/dashboard and also passed the filters of the parent report dashboard here. So we need to know what all are the currently applied
Read More