 Enterprise Reporting & Business Insights Platform |
|
Enterprise Reporting & Business Insights Platform |
The major enhancements available in Intellicus 5.2 are :
Dynamic creation of SQL of Query Object based on selection of fields
Facility to hide SQL data source information from end user of web studio
HTML Preview in Desktop Studio
Availability of Line control in Web Studio
Configure Rendering Section of Page Header Controls
Option to set Database connection of all child objects
Group level page count
Intellicus 5.2 SP1 now exposes the object structure of Adhoc template and opens many possibilities.
One such is the creation of dynamic SQL based on fields selected for Adhoc reports. The SQL of query object is thus created at runtime (based on selection of fields from Adhoc wizard and power viewer). This dynamic SQL is thus specific to selections instead of selecting everything. This helps to improve the performance of SQL execution.
Please note that you can achieve this by writing scripting code in your query object as shown below. It is recommend to go for this approach if you have large number of fields in your Query Object..
Without scripting code SQL fetched all columns.
With scripting code SQL fetched selected columns.
Intellicus 5.2 SP1 can empowers your users to edit the report layouts of the shipped canned reports, if so desired, from the Intellicus Web Studio. This facility is extended to them while keeping the SQLs that you ship secure (not available for editing).
End users of web studio can only modify canned report layouts and save as their customized reports.
(Please note that this feature can be implemented by applying customization over standard setup of Intellicus 5.2 SP1. Please contact Intellicus for more information)
Below image shows the SQL editor and parameter window (marked) are available to you but these are not available to your customers for any modification.
You as Shipper/Designer
(SQL source and parameter window are not available to your customers after applying the customization)
Intellicus 5.2 now provides the ability to preview the HTML reports from the Desktop Studio directly.
Earlier, you had to create the report and then had to deploy it to the portal to see how the design has come out to be. This proved to be a bit cumbersome at times of frequent changes required during the designing.
Set the required options on the Desktop Studio.
Preview in the Viewer.
There are some known limitations for this enhancement. These are :
1. Even after login to studio, while previewing the report in HTML format for the first time, a login is needed to the web client application.
2. Report does not run on first attempt after login to web client application.
3. Every time when session expires on web client application, limitations 1 and 2 are seen.
Intellicus 5.2 now provides support to design line control and configure its properties through Web Studio.
Intellicus 5.2 has introduced RenderingInSection property for controls of Page Header. You can now control the rendering of page header controls at caption header or page header section through this property.
This property is available in Desktop Studio and Web Studio.
Example:
Date and Time at Page Header Section:
Date and Time at Caption Header Section:
u can now set a Database connection for all child objects like chart, cross tab and sub reports at the time of setting connection for parent report.This helps you govern the connections for various components easily, when they all use the same database connection
This option is available in Desktop studio only.
Intellicus 5.2 provides support for group level page count. Previously, you needed to write a script in order to get group level page counts.
Now, For a grouped report, if a field control is placed in Page Header or Page Footer or Group Header section and its properties are set for a specific group, the report will display page count and page total specific to that group.
Note : The page count will reset to 1 when group values changes.
Setting Properties for Page count :
Properties for Page Total :
Group level page count for Direct Sales channel group:
Group level page count for Mail Sales channel group:
