Pivot View > Pivot Table View

The Pivot view is only available in the Pivot version of ExReport.

This feature enables you to summarize and analyze data in lists and tables. Pivot tables are called such because you can quickly rearrange the position of pivot table fields to give you a different view of the table.

Because ExReport allows you to query the database any way you like with SQL a result set is out put to the Pivot and you can arrange the data in many different ways to sum the totals and create elaborate views of the data not possible in Exchequer.

The performance of ExReport is such that reports that take hours to create can be done in minutes.

A simple double click on a value in the Pivot drills down to the actual query records that make up the summary.

With the drag-and-drop functionality, it allows you to rearrange fields in the view dynamically, without having to change the structure of the data store. They can interchange columns and rows on the fly, filter and sort items in different ways, and also collapse and expand data at different levels. Thus the desired report can be obtained immediately. A side benefit is that – no code is required for generating reports of different types. Data is analyzed from a user’s perspective.

You may find it handy, if you need to:

•	Produce multidimensional reports on a set of an ordinary data.

•	Analyze the data that is involved in a multidimensional relationship.

•	Instantly organize related data together.

•	Spot trends of the data in the fastest way.

Along with the solutions to the above tasks, the Pivot table offers an essential functionality to succeed in business reporting.

To efficiently perform an analysis, the pivot mechanism requires that:

❖	Automatic summary calculation for each cell – There are 9 summary functions available: Sum, Count, Min, Max, Average, Standard Deviation based upon a sample, Standard Deviation based upon the entire population, Variation based upon a sample and Variation based upon the entire population.

❖	Any number of data fields – This feature allows you to calculate and display multiple summaries at the intersection of each column and row.

❖	Any number of column and row fields – The values of column and row fields are listed along the top and right edges of the control and they identify column and row headers. The values of multiple column (row) fields are arranged into a hierarchy and can be expanded.

❖	Automatic Total calculation – Totals (which are inserted as additional rows or columns) display total summaries calculated for outer column and row fields.

❖	Automatic Grand Total calculation – Grand Totals display overall summary totals calculated against all the columns and rows. They are displayed as the bottommost rows or rightmost (leftmost) columns.

❖	Multiple Totals – It's possible to calculate multiple Totals for specific column and row fields.

❖	Filtering data – This feature enables you to limit which records are processed by the Pivot. You can easily change the filter via the pre-filter panel or filter drop down.

❖	Automatic sorting of column and row field values in alphabetical order (for text data) and in order of magnitude (for numeric and date/time data). Change a field's sort order (from ascending to descending and vice versa) by clicking the field header.

❖	Print support – the contents of the Pivot can be printed out via the PDF Reporter.

❖	Export – Excel.

❖	Cell selection and copying to clipboard – Select a range of cells with the mouse and then copy their contents by pressing the CTRL+C shortcut. The selected data is copied to the clipboard in the tab-separated format that is natively supported by Microsoft Excel, for instance.

❖	Dragging fields between different areas – you can freely drag field headers between different control areas. This gives you full control when analyzing the data.

❖	Built-in Customization Form – Allows you to temporarily hide fields and make them visible again.

❖	Built-in context menus – Provide access to the most commonly used features.