Intellicus Enterprise Reporting and Business Insights 19.0

Report Scripting

0 views June 28, 2020 0

Intellicus Studio provides facility to customize the events using the Script Editor. Coding is done in JavaScript syntax, and is event based. The following table lists the events that are supported/provided at report level.

Report level events

Important: You need to make sure that the code pertaining to a particular event is written within the appropriate event only.

Event Description
OnReportStart This event is fired before report objects such as fields and sections are constructed. (Before the report starts to execute itself)
OnReportEnd This event fires after execution of the report.
OnPageStart This event is fired before displaying every page. This event does not ensure that the previous page’s display has been completed.
OnPageEnd This event is fired after the display of every rendering.
OnHyperlink (Button, Link) This event is fired when the end user clicks on the hyperlink on the report output. The mouse button and the URL are passed in as parameters.
OnDataInitialize This event is fired after the report is loaded, or SQL statement is fired or SQL fields are created. In this event, new report fields can be added and existing fields removed.
OnFetchData (eof) This event is fired after each row of the report SQL statement is fetched from the database. In this event, the report field’s data can be accessed for calculation and manipulation.
OnNoData This event is fired when zero rows are fetched from the report SQL statement.
OnPrintProgress (PageNumber) This event is fired when the printing progresses to next page. The printing process refers to sending the page data to the printer driver and not printing the page on the paper.
OnError

(Number, Description, Scode, Source, HelpFile, HelpContext, CancelDisplay)

This event is fired when any error occurs while running the report. In this event, the error messages can be changed or can be suppressed.
Section level events

Intellicus passes three events at section level for all sections. The sequence of events depends on the summary objects and their section dependencies. The event sequence is:

OnFormat

This event is fired after the data is loaded and bound to the fields, but before the section is laid out for printing. You can use this event to modify the layout of the section or any of the controls on it.

Note: This is the only event in which you can modify the height of the section.

OnBeforePrint

It is fired before the section is rendered to the ‘Canvas’ object. You can use this event to modify the values of the controls before they are printed. Any changes that are made here will not affect the height of the section.

Important: It is recommended, NOT to access any report fields in this event. If you need the value of a field in this event, you should use a hidden control to store the value temporarily in the format event.

OnAfterPrint

It is fired after the section is rendered to the ‘Canvas’ object. You can use this event to update any counters that you need to use after the report is completed.