| sreformat | Index Level | sselect |
| Syntax | ss attr.name1 {{beg.date} {end.date}} attr.name2 {(g} |
| Category | Access |
| Type | Modifier |
| 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. |
| Options | g Suppresses the row and column totals. |
| See Also | attr.name roll-on Access Spreadsheet Connective |
| 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". |
| Warnings | When the "attr.name1" display width is greater than the "attr.name2" display width, the output may flow off the right side of the screen or printout. This will be fixed in a later release probably by using the greater of the two widths to determine the number of columns to use. |
| Compatibility | D3 7.0 AP |
| sreformat | Index Level | sselect |