Helical Canned Reports: Getting Started

Helical Canned Reports is a new module that has been introduced in Helical Insight 4.0. This module enables the users to create canned reports or pixel perfect pre-formatted reports. These reports are scalable, pixel-perfect, multi page reports which are also printer friendly. Canned reporting module can be used to create reports like invoices, balance sheets, purchase orders, performance reports, survey forms etc. If your reporting requirement also has mainly a simple table but with many pages, Canned Reporting module is much more suited as compared to Adhoc Report.

In this module we would be just giving a preview. Users are requested to go through the detailed blogs to learn about the usage of the functionalities properly.

To open this module, click on Canned Report button. The following page will appear:

In order to start making a new report, click on “+” button. Only a maximum of 4 tabs can be opened in the canned reports module at a time; either in create or in edit mode

Once we click on “+” at the top we can see the below kind of functions starts appearing

  1. Shortcut: By hovering on this button, you can see all the keyboard shortcuts available

  2. Home: Going to the home page of Canned Reporting module
  3. Save / Save As: Useful for saving the report. When clicked File Browser will appear, a user can create new folder / select a folder and then save it there. Save As can be used for making a copy.
  4. Share: To share the report with other users/roles/organisations

    5. Know more about sharing here Sharing Reports

  5. Preview: You can preview the report while you are creating the report. As you are making the report it is always advisable to keep on previewing the report and see how it is appearing
  6. Toggle Panes: By clicking on it various panes like Property Pane, Symbol Pane and Tabs Pane can be hidden / viewed on the browser.
  7. Notifications (Bell Icon): Notifications can be seen here
  8. Lastly we have logout button

On the extreme left, you can see Canvas, DataSource & Reports buttons. You can use these buttons to navigate between Canvas, Datasource page and the File Browser.

REPORTS BUTTON:

When you click on the reports button, it opens up the file browser. You can navigate to the report you want to edit from this section. It has a search section as well to search the report by name. In order to open a report which is already created you can double click on the report and it will open(drag drop operation on the report name will not work, double click report nameto open it in edit mode). You can return to canvas or datasources page by clicking on the respective button which appears on the top right corner of the report browser.

DATASOURCES PAGE

In order to start creating a report, first you need to create a datasource connection and query. Please go through the blog DataSource Overview to read more about the various kind of connections in datasources (managed, global, groovy etc), input parameters type and configuration etc.

When you click on datasource or New Connection on the datasource pane, then the datasource page opens. On the right hand side, there is a datasource pane. This pane has 3 sections:

  1. Connections : This is the section where you can add connections and configure them. Read the datasources blog to learn more. Multiple connections can be made.
  2. Queries: This is the section where you can add multiple different queries, point it to the datasource created above. The dataset of the query can be previewed.
  3. Parameter: If you need input parameters, then you need to add them in this section. Learn more here.

Queries:

CANVAS

Once you have created the query and required input parameters (filters), you can create the report by going to the elements page. Click on Canvas button. On the elements page, you can see text and line components on the left section. You can drag these components and place them onto the canvas in the middle section. Go through the below mentioned blogs to learn more about the usage of Text Component, Line Component and Image Component.

On the right hand side, we have the datasource panel and property panel.

The datasources pane will show a list of various SQLQueries written and selecting any of the query will show the fields output of that specific query. Also, there are calculated fields and input parameters that will appear in this section. We can drag any field or input parameter that we want to use onto the canvas and place them the way we want and make use of them.

The property pane is used to set the properties of the report or individual components. These properties options which appear are dependent on the kind of component that you have selected and accordingly those properties options will appear. On the below image the properties options which are appearing are related to the “Report” like the report page setup, margins, borders, define styles for components, calculations for fields and alignment of various components in this area.

In the below mentioned blogs we have covered in details the properties options avalaible for different components

Repeat By Usage

When creating reports in certain cases we might need to have text or content which is present once at the starting of every report (like a report header), or once towards the ending of the report (like a report summary), or once per every page at the top or bottom (like page header or page footer) or showing the entire data by executing the SQLQuery. When a component is selected and then we right click we get “Repeat By” option which allows us to implement such things like report header, report summary, page header, page footer, actual data.Learn how to use “Repeat By” functionality in detail.

Group By Usage

In certain cases when we create a report it might also require subgroup wise total or count. For example we are creating a Product Wise Geography wise Sales, in the created report we might also want to show what is the subtotal for each and every geography as well. In those kind of cases the concept of “Group By” can be used. Learn Concept and usage of Grouping

Quick functions usage:

While creating reports we might need to show the total page number, current page number, running count, current date, current time etc. There are a lot of quick calculations and functions which are present which allows us to show this. Usage of quick functions

Now there can also be certain cases wherein the prebuilt calculations are not sufficient and you want to create some custom calculation. In those cases custom calculation option can be used.

Custom Calculations

Custom calculations options allows you to create your own custom calculation by using fields and defining custom formulaes. Go through this blog to learn how to create your own custom calculation and use it

Field Calculations on Right Click

There are various calculations that are available on right click on any field. Refer to our detailed blog to understand the usage of calculations on right click

Alignment Options

By selecting a component we can specify its position and size. There are alignment options which are present in the properties with a more granular pixel perfect control (like its X position Y position Height and Width in terms of pixels). Aside when you have selected a specific component there are some quick alignment options which like fit to width, stick to top etc. Learn more here about those quick alignment options. There are a lot of other right click operations which can be learned by this blog
Usage of input parameter

If you would like to display the value of input parameter which has been selected that is also possible. You can simply (need to try out this first). The reports which are created using canned reports supports various kind of exporting options. The exporting options of canned reports module includes options like HTML, CSV, XML, XLSX, PDF, RTF, DOCX, ODT, ODS, PPTX, TXT, XLS, PNG, JPEG and JPG. The canned report can be opened from the file browser in a new tab.

The reports created with canned reports also have many more email scheduling options. When you are on the interface of email scheduling it gives certain more kind of email scheduling options which includes HTML, CSV, XML, XLSX, PDF, RTF, DOCX, ODT, ODS, PPTX, TXT, XLS, PNG, JPEG and JPG

The method of email scheduling the canned reports are similar to other. You can go through the blog to learn more Email Scheduling Reports and Dashboards

For further assistance, kindly contact us on support@helicalinsight.com or post your queries at Helical Forum

You May Also Like

Helical Insight’s self-service capabilities is one to reckon with. It allows you to simply drag and drop columns, add filters, apply aggregate functions if required, and create reports and dashboards on the fly. For advanced users, the self-service component has ability to add javascript, HTML, HTML5, CSS, CSS3 and AJAX. These customizations allow you to create dynamic reports and dashboards. You can also add new charts inside the self-service component, add new kind of aggregate functions and customize it using our APIs.
Helical Insight’s self-service capabilities is one to reckon with. It allows you to simply drag and drop columns, add filters, apply aggregate functions if required, and create reports and dashboards on the fly. For advanced users, the self-service component has ability to add javascript, HTML, HTML5, CSS, CSS3 and AJAX. These customizations allow you to create dynamic reports and dashboards. You can also add new charts inside the self-service component, add new kind of aggregate functions and customize it using our APIs.
Helical Insight, via simple browser based interface of Canned Reporting module, also allows to create pixel perfect printer friendly document kind of reports also like Invoice, P&L Statement, Balance sheet etc.
Helical Insight, via simple browser based interface of Canned Reporting module, also allows to create pixel perfect printer friendly document kind of reports also like Invoice, P&L Statement, Balance sheet etc.
If you have a product, built on any platform like Dot Net or Java or PHP or Ruby, you can easily embed Helical Insight within it using iFrames or webservices, for quick value add through instant visualization of data.
If you have a product, built on any platform like Dot Net or Java or PHP or Ruby, you can easily embed Helical Insight within it using iFrames or webservices, for quick value add through instant visualization of data.
Being a 100% browser-based BI tool, you can connect with your database and analyse across any location and device. There is no need to download or install heavy memory-consuming developer tools – All you need is a Browser application! We are battle-tested on most of the commonly used browsers.
Being a 100% browser-based BI tool, you can connect with your database and analyse across any location and device. There is no need to download or install heavy memory-consuming developer tools – All you need is a Browser application! We are battle-tested on most of the commonly used browsers.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
A first-of-its-kind Open-Source BI framework, Helical Insight is completely API-driven. This allows you to add functionalities, including but not limited to adding a new exporting type, new datasource type, core functionality expansion, new charting in adhoc etc., at any place whenever you wish, using your own in-house developers.
A first-of-its-kind Open-Source BI framework, Helical Insight is completely API-driven. This allows you to add functionalities, including but not limited to adding a new exporting type, new datasource type, core functionality expansion, new charting in adhoc etc., at any place whenever you wish, using your own in-house developers.
It handles huge volumes of data effectively. Caching, Pagination, Load-Balancing and In-Memory not only provides you with amazing experience, but also and does not burden the database server more than required. Further effective use of computing power gives best performance and complex calculations even on the big data even with smaller machines for your personal use. Filtering, Sorting, Cube Analysis, Inter Panel Communication on the dashboards all at lightning speed. Thereby, making best open-source Business Intelligence solution in the market.
It handles huge volumes of data effectively. Caching, Pagination, Load-Balancing and In-Memory not only provides you with amazing experience, but also and does not burden the database server more than required. Further effective use of computing power gives best performance and complex calculations even on the big data even with smaller machines for your personal use. Filtering, Sorting, Cube Analysis, Inter Panel Communication on the dashboards all at lightning speed. Thereby, making best open-source Business Intelligence solution in the market.
With advance NLP algorithm, business users simply ask questions like, “show me sales of last quarter”, “average monthly sales of my products”. Let the application give the power to users without knowledge of query language or underlying data architecture
With advance NLP algorithm, business users simply ask questions like, “show me sales of last quarter”, “average monthly sales of my products”. Let the application give the power to users without knowledge of query language or underlying data architecture
Our application is compatible with almost all databases, be it RDBMS, or columnar database, or even flat files like spreadsheets or csv files. You can even connect to your own custom database via JDBC connection. Further, our database connection can be switched dynamically based on logged in users or its organization or other parameters. So, all your clients can use the same reports and dashboards without worrying about any data security breech.
Our application is compatible with almost all databases, be it RDBMS, or columnar database, or even flat files like spreadsheets or csv files. You can even connect to your own custom database via JDBC connection. Further, our database connection can be switched dynamically based on logged in users or its organization or other parameters. So, all your clients can use the same reports and dashboards without worrying about any data security breech.
Our application can be installed on an in-house server where you have full control of your data and its security. Or on cloud where it is accessible to larger audience without overheads and maintenance of the servers. One solution that works for all.
Our application can be installed on an in-house server where you have full control of your data and its security. Or on cloud where it is accessible to larger audience without overheads and maintenance of the servers. One solution that works for all.
Different companies have different business processes that the existing BI tools do not encompass. Helical Insight permits you to design your own workflows and specify what functional module of BI gets triggered
Different companies have different business processes that the existing BI tools do not encompass. Helical Insight permits you to design your own workflows and specify what functional module of BI gets triggered