Specifying Criteria

Data selection is the heart of the PS/nVision layout. The database values retrieved for a matrix-based report are the results of intersecting criteria defined in the matrix layout. These criteria tell PS/nVision exactly which database values to retrieve and where to put them. The values retrieved from a tabular layout are not row and column intersections but the results of a query. Each instance is a list file representing either a partial or complete answer set for that query.

You can specify data selection criteria at the level of the entire spreadsheet, a row or column, or an individual cell. Generally, you specify criteria at the highest level applicable. So, if you have criteria that apply to the entire worksheet, you specify them at the worksheet level; if you have criteria that are unique to a single cell, you apply them to that cell only.

If there is a conflict between row and column criteria, the row overrides the column criteria. Cell criteria override all other criteria, followed by row, column, and finally worksheet criteria at the lowest level of the hierarchy.

Note:

nVision should not use trees with a mixture of dynamic details and range details. The results returned from the reports using such trees could be inaccurate.