Canned Reporting : Page Setup

In this blog, we will cover the page properties like page size, background etc. The report page properties options appears when we have clicked on the report (and not on any component like text line etc) and then on the right side we can see various kind of properties options. We will be explaining those properties options here.

PROPERTY PANE

The property pane is used to set the properties of the selected component.

When you click on empty canvas or empty section of the canvas, the properties for the entire report can be set.

  1. Page Setup: You can select the page size and orientation in this section of the report that you would like to create. Based on the kind of report that you would like to create there are various kind of options like A0, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, B0, B1, B2, B3, B4, B5, Legal and Letter.

    2. Page orientation can be either Portrait or Landscape.

  2. Margin: You can set the Top, Left, Bottom and Right margins for the page. The margins specified here are in pixels.

  3. Page Properties: In this section you can set the default properties to be used on a page.

    1. Column Count: This is the number of columns into which the entire report should be divided into. For example in a single report you want to print fees, one is management copy and the second is end user copy. Then in column count we will specify 2 and in each column a report will be created.
    2. Column Spacing: Defines the spacing between two adjacent columns if the report is divided into more than 1 columns.
    3. Column Width: This is defined when the report is divided into more than 1 columns. The width of column can be defined.
    4. Print Order: When there are multiple columns, whether the data should be printed row-wise or column wise that can be specified here. Print order can be horizontal or vertical.

      5. Example of Horizontal Printing- The records are printed row-wise. So the first record is in the first row first column and second record is in the first row second column

      Example of Vertical Printing- The records are printed column-wise. So the second record is printed in the same column as the first record. Records are printed in the second column when the first column height is exhausted.

    5. When No Data: Defines what to display when there is no data available for the selected fields.

    The various options present here are :

    1. All Section No Details – This will show all the sections but there will be no data that will be printed. So, the template will still be visible.
    2. Blank Page – A blank page will appear when there is no data.
    3. No Data Section – A section will be printed on the page which will have a custom script. This script can be set by right clicking on the text box which you want to display when there is no data and selecting Repeat option as No Data.
    4. No Pages – If this is selected, then you will not see any page at all when there is no data.
    5. Summary with header and footer: Select if the summary must be available in a separate last page along with header and footer. By default summary is without header and footer. (confirm)
    6. Float column footer: Select if the footer should appear at the bottom of where the data gets over instead of at the very bottom of the page. (confirm)
    7. Title in New Page: The title of the report will be printed on a new separate initial page. The topmost component will be taken as the title. (confirm, also how can we create a title)
    8. Summary in new page: Select if only summary should appear on the last page separately. The bottom most component will be taken as summary. (confirm)
    9. Ignore pagination – all the data is visible on single page.

  4. Page Styles: You can define a set of styles to be used throughout the report. You can save this style and select it after selecting the components that will be using this style. In this section you can set the following properties like
    1. Font style and size
    2. Fore color and background color
    3. Alignment – Various kind of alignment like left align, centre align, right align, centre align, top align, bottom align, centre align.
    4. Rotation – this defines the orientation of the text in the cell. Left means it will rotate anticlockwise by 90 degree, right means it will rotate clockwise by 90 degree, upside down will rotate the text by 180 degree.
    5. Padding – defines the space between the border of the component and actual text or data
    6. Border -you can define the thickness of the border stroke, color and style of the border
    7. line styles – defines the style to be used for line component.
    8. Markup – You can set the markup format that should be used to embed the style component in the text component.
    9. Mode – When set to transparent, background color will not be visible. Set to opaque to view the background color.
    10. There is a check box which can be selected to display a blank in case any value is Null.
    11. If you want to set any style as default, then you can select the Default Style checkbox.
    12. In the pattern section, you can give the desired format of the text/data to be displayed.

    After defining the style, you can select any component on the canvas and in component properties, you can select the style to be used.

  5. Calculations: In this section, you can define the custom calculations. Things like running sum or group sum, percentages, ration etc and other custom calculations can be defined here. You can go through this blog to learn in detail of how to apply calculations.

  6. Preview Parameters: Select whether or not to show the parameters on the frontend while a person is viewing the report in read mode. Even if “Show Parameters” is not selected even then the values of the filters can be passed from the URL. This is more specifically useful when we are looking into embedding and passing the values from the URL itself and not giving the end users the option to actually change the input parameter values.

    7. Aside the input parameters values position can be either Left, Right, Top, Bottom when a person is viewing the report in read mode. You can read out separate blog to learn how to add input parameters and configure it.

    When a text/line component is selected, the property pane changes so that the relevant properties of individual components can be set. You can read more about these properties in the respective blogs.

  7. Group Properties: You can set the properties for any particular group using this section. The following options are available:
    1. Select Group – Select the group that you are setting the property for.
    2. Minimum height to start new page – Minimum height after which the data should appear on a new page.
    3. Minimum records to start from top – Define the number of records to be rendered on the current column, so as to avoid starting the group on a new column
    4. Reprint header on each page – checkbox, if selected, on every page, the header of the group will be visible.
    5. Keep together – select to keep all the records of a group together
    6. Start new column – select to start a new group in new column
    7. Start new page – select to start a new group on a new page
    8. Reset page number – select to reset the page number after each group
    9. Prevent orphan footer – select to

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