Tag: BI tool

Canned reporting interface provides one more method of implementing multiselect parameter and that is using checkbox. In this blog we are going to cover how to implement the same. Below is a snapshot of how the checkbox input parameter looks like STEP 1: Create a connection To know more about the types of datasource connections

In this blog we will see how to create a canned report with a date picker as input parameter. We will give an end user an option to select the date, and all the data greater than that specific date will be available in the report. STEP 1: Create a connection To know more about

In this blog we shall see how to create canned reports with input parameters with single select. 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

In this blog we will see how to create a canned report with a date range selector as input parameter. 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

In this blog, we are going to see how to connect to the Datasources page in the canned reports module and other features present on the page. In order to go to the datasources page, click on the Datasources button on the left hand side of the canvas or on New Datasource in the datasource

Introduction: While working on Canned reporting, there are different types of input parameter options which are available. The same we would be covering in details in this document. Input parameters types which are present includes options like select (drop down value selector), select2(searchable dropdown selector), checkbox (multiselect), datepicker, daterangepicker , input, button, checkbox and slider.

In this blog, we will see how to add custom calculations in Helical Canned Report module. These calculations will be added to the Calculations/Parameters section in the datasources pane and can be used in the report. By default, in the canned report module, there are various calculations available by default. However, if you want to

In this blog, we will see the usage of the quick functions or calculations available on the datasources pane of Canned reports module of Helical Insight. All the calculations when dragged onto the canvas appears with the extension $V{function_name} The calculations listed in the datasources pane can be used directly into the reports as variables

In this blog, we are going to see how to use groups in Helical Canned Report as well as usage of Group_Count function. A group is a set of field values in the result set. You can create different groups and then repeat components for each group. You can create a group for a field