Grouping of Report Fields on Adhoc Report Wizard across all sections

In this release, If grouped report fields are present in a Query object then on Adhoc Report Wizard the listing will be shown as grouped fields across all sections like 'Select Display Fields', 'Select Filter Criteria', 'Select Grouping', 'Select Totals' and so on.Designers can easily select random display fields listed under both 'grouped' and 'ungrouped' category, and move them to the selected fields column in a single click.

'Find' feature is also available across the section. As shown above this feature helps you to locate the desired field accurately in a long list of fields as you enter the string in the search box.

Fetch Modes for Lookup Values available in Lazy and Search mode

Two New Fetch modes are provided to help designers and users get improved performance on Intellicus portal for data search results during lookup value operation. While Creating  lookup query for a particular field, designer can now choose the Fetch mode depending on his/her need. Different 'Fetch' modes provided are 'Now', 'On Every Use', 'Lazy', 'By Search'.

for example:- When you choose 'Lazy' fetch, the data (on Adhoc wizard) is populated in the value column of filter when you click on the combo.

On the other hand if the designer choose "By Search" as the fetch mode than the user will be able to search values for the filter field by entering the first few characters of the value. As shown in figure already selected values are shown just below the filter.

If Designers need to populate the lookup values of  field (City) based on values selected in another field say (State) then he/she can create a Lookup linking as shown in figure.

So now on Adhoc report wizard when designer apply the filter of State and select a value say 'CA' then the values populated when City is chosen as filter will be only those whose state is 'CA'