| Title: | FOCUS, from INFORMATION BUILDERS |
| Moderator: | ZAYIUS::BROUILLETTE |
| Created: | Thu Feb 19 1987 |
| Last Modified: | Mon May 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 615 |
| Total number of notes: | 1779 |
I'm trying to create a report which prints across the page. When I execute the fex below, I get the following error message: NUMBER OF VALUES RETRIEVED FOR ACROSS EXCEED 64. From reading the documentation, I understand 64 is a limitation with ACROSS. Is there any way around this? DEFINE FILE CAP DCQ_ID/I1 = EDIT (D_QUESTN_ID); END TABLE FILE CAP SUM DCQ_EVL_RESP IN +0 ACROSS DCQ_ID NOPRINT END Thanks, Kris
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 344.1 | Avoid the limit! | CRATE::HERSHMAN | Wed May 30 1990 04:40 | 13 | |
Three possibilities:
(1) If you only need selected values, not all, specify them;
ACROSS <field> COLUMNS <val1> AND <val2> AND ... [2-37]
(2) If you can manage with ranges instead of single values:
ACROSS <field> IN-GROUPS-OF ... [2-37/38]
(3) Break the file up into selected ranges, and report on each
range independently.
Brian Hershman
| |||||