ICROSS(Index CrossTab)

JOIN -> User can merge two sql using INDEX1 and INDEX2 with defining JOINTYPE INNER/LEFT etc.

e.g.:

KEY -> User can set key field as per define complex view to transform of view’s data.

JOINTYPE -> User can set type of joins using this key field like inner, left join etc.

ICROSS -> User can define ICROSS transform like this.

e.g.:

IDField-> User can set key ID field as per taken key field under JOIN tag.

AGGCOL-> User can set columns for transform and to be visible under taken Group value.

TARGET-> User can set value for Target column like 0.

CAPTION-> User can set caption for columns of transform using this tag.

SORTCOL-> User can set column for sorting data of view using this tag.

GROUP-> User can set group name for columns of transform using this tag.

Output: