Report Wizard - Cross-Tab Tab

<< Click to Display Table of Contents >>

Navigation:  »No topics above this level«

Report Wizard - Cross-Tab Tab

Previous pageReturn to chapter overviewNext page

 

The Cross-Tab tab allows you to define the information that is needed to create a Cross-Tab report. To create a Cross-Tab, you must specify a row and column data expression as well as a summary function.  The row and column data expressions define what information is used to create the cross-tab.  The summary function defines what action is performed on the data.

 

_bm35

 

ReportPro performs the following steps to create a cross-tab report.  First ReportPro searches through the data source for all unique values returned by the column and row data expressions.  After it has found all the unique values for each expression, ReportPro sorts those values in ascending order.  For each unique value returned by the column data expression, ReportPro will create a column in the cross-tab.  For each unique value returned by the row data expression, ReportPro will create a row in the cross-tab.

 

Next, ReportPro will find all the locations in the database where the values returned by the row and column data expressions intersect on the same logical record.  When it finds a 'hit', ReportPro will perform the specified summary function.  The Summary Function combo box allows you to specify which mathematical operation to perform.  There are five summary operations available.

 

Function

 Description

Average

 Determines the average of all cross-referenced values

Count

 Counts all cross-referenced values

Maximum

 Determines the largest cross-referenced value

Minimum

 Determines the smallest cross-referenced value

Sum

 Sums all cross-referenced values

 

If the summary function is Count, ReportPro will simply count the number of times the row and column data expressions intersect in the data source and place that number in the cross-tab.  If the summary function is other than count, then a summary data expression is required.  In this situation, ReportPro evaluates the summary data expression and performs the summary function on its return value.  

 

The column and row display expressions are used to determine what values are actually displayed in the cross-tab column and row headers.  Often these expressions differ from the expressions used to extract the row and column data because the latter must be defined in a way that can be sorted while the display expressions tend to be a more readable format.

 

Each of the expressions described above can be entered directly into the appropriate edit control or can be entered via the Expression Builder by pressing the _bm11 button next to the edit control.

 

The Picture edit, which is available for each expression, allows you to specify an optional picture clause that is used to format the display expression's return value.

 

 

Also See:

 

Report Wizards

Cross-Tab Report Wizard

Pictures Codes