You can turn every FindBrowse grid into a pivot table just by customizing the format settings.

How to

1. Open the format settings and change the format type to FindBrowse Pivot.



2. Open the format Drag&Drop dialog and:

• Put the pivot column in the first position of your output fields. Open the field settings dialog and change the "Group by" option to yes and set the "Order by" position to 1.
  
• Put the pivot row in the second position of your output fields. Usually you should open the field settings dialog and set the "Order by" position to 2.
  
• Put the pivot detail fields after the first two fields of your output fields.
  

Hints

• If there is no detail data for column/row combination a "-" is displayed.
• In a pivot table normally it doesn't make sense to use multiple grid pages. So the "Records Export" value is used for the number of rows to fetch.
• You are able to use all normal gird features in a pivot table like fulltext search etc.

Example

FindBrowse grid before format type = "FindBrowse Pivot"



FindBrowse Pivot