Ad-hoc Reporting Enhancements

Multiple charts in single Ad hoc Report

You can now create multiple charts on an Ad hoc report.

Chart section is provides + button to add more charts and specify the chart details in the new chart tab.

In the Ad hoc template you can control the number of charts displayed by the size. More charts flow to next row.

Chart power viewer enhancement

Chart power viewer has been enhanced to provide options to show or hide Point labels and Legends, without going back to wizard.

Highlighting in Matrix

The Highlighting feature has been extended to Matrix view of data. You can highlight a Cell, Cell Family, or an Entire Row or Column of a matrix based on a condition.

Highlighting a Cell family

Highlight a cell with its headers - both row header and column header

Highlight entire row or column

The matrix highlights the cell that caused highlighting separately as bold and gives you options to highlight

a) only the cell b) group of cells or c) entire row or column

Collapsed view of Ad hoc matrix

Intellicus 6.4 provides an option to the Designers to keep the matrix in collapsible form when report executes.

The property to keep matrix collapsed is exposed in the template that the designers can set using these lines:

if(rpt.Sections("ReportFooter").contains("CROSSTAB0") == true)

{  var crsstab = rpt.Sections("ReportFooter").getControl("CROSSTAB0");
   crsstab.setDefaultCollapseExpandState(1); // 1 is to set initial state as collapsed;
   // Default initial state is EXPANDED (i.e. 0)
}

On the viewer, user can click on desired group header values to expand required section of the matrix.

Upon export or printing full matrix is expanded.

Lazy fetched lookup values on Power viewer

Power viewer available at Report and Matrix controls can now fetch the field values in Lazy mode.

This enables very light weight and fast rendering of reports and end users will have an access to the fresh set of values on-demand without an impact on performance.

User chooses to apply filter on field with large distinct values:

User can choose multiple values to apply the filters

Users also have an option to deselect or fetch more values to apply filter.