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
We shall see how to create canned ALL as one of the options in the 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
Read More
Implementing Data Security In Canned Reports Based On Logged In User’s Profile Name and Profile Values Introduction: In this blog we are going to explain how to implement data security based on the user’s profile attributes. We have created sample tabular report having the data of client wise meeting date. A user can have multiple profiles
Read More
Introduction: In this blog we are going to explain how to implement data security based on the logged-in role name. We have created sample tabular report having the data of client wise meeting date. In this example, we want to filter the data based on the role of the user who is logging in. Please make
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
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
Read More
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
Read More