access.ss Modifier/Access: Verbs

access.ss

Command access.ss Modifier/Access: Verbs
Applicable release versions: AP
Category Access: Verbs (152)
Description produces columnar and cross totals on rows of designated attributes within a given range of dates.


attr.name1 is the attribute-defining item containing a date which limits the tabulation. The output form of this attribute determines the column headings. The output form of "attr.name1" does not have to be the same as the values included in "beg.date" and "end.date". For example, "attr.name1" may display the month, while "beg.date" and "end.date" must be in the form "mm/dd/yy" enclosed in double quotes (").

beg.date is the beginning date range to be included. If not specified, "beg.date" is determined by the number of columns that will physically fit on the display or printout.

end.date is the ending date range to be included. If not specified, the current system date is used as the default.

attr.name2 is the attribute that contains the values to be columnar and cross (row) totaled.


If the width of the report exceeds the width of the output device, the extra columns are truncated.

If two or more "ss" connectives are used in the same Access sentence, a single report is generated, with columns for each subsequent "ss" connective following the totals column for the previous connective.

Column headings are created for each possible value produced by "attr.name1" within the "beg.date" and "end.date" range. Output-conversions are processed before producing the heading. Correlatives are not processed. The format of the column is determined by "attr.name2".

Each cell in the listing contains the total value of "attr.name2" for the date specified in that column heading.

"roll-on" can be used in conjunction with "ss" to produce subtotals by specified categories. Each rolled attribute value produces a row in the output. If no "roll-on" is specified, only a total line is produced.

The granuality of the date display is determined by the output-conversion of the "attr.name1". The date granuality is the value of the last multiply in the output-conversion. If the following output-conversion is used to provide week ending dates, the report will have a granuality of 7 days and the dates will be the Saturday after the date in the item. In both of the following examples, the date is stored in attribute 4.


a4/'7'*'7'+'6'
d2/


Whereas the following output-correlative makes a granuality of 3 days:


a4/'3'*'3'
d2/


The number of dates to display is based upon the display width of the "attr.name2" attribute, but the width of the columns on the report is based upon the greater of the "attr.name1" display width and the "attr.name2" display width.
Syntax ss attr.name1 {{beg.date} {end.date}} attr.name2 {(g}
Options g Suppresses the row and column totals.
Example
sort invoices with code "c" "d" and with amount ne 
"" by code by category ss quarter "01/01/92" 
"12/31/92" amount roll-on code roll-on category 
"'d'" det-supp id-supp

The previous example produces a report with subtotals for each "code" 
and totals to each category within the code for the quarters "1-92", 
"2-92", "3-92" and "4-92".

sort invoices by customer ss quarter "06/30/92" amount roll-on 
customer det-supp id-supp

This produces a report by customer for three quarters, "4-91", 
"1-92", and "2-92". The beginning date range is calculated 
based on the attribute's width, the output device's width, and the 
ending date of "06/30/92".
Purpose
Related access.attr.name
access.roll-on
access.introduction
spreadsheet.article