Arrange by is used with subtables and order by is used by maintable
Dan Goldberg ________________________________ From: [email protected] <[email protected]> on behalf of Bruce Chitiea <[email protected]> Sent: Tuesday, July 4, 2023 3:39:12 PM To: [email protected] <[email protected]> Subject: [EXTERNAL] [RBASE-L] - SubReport Sorting Fail All: A report "testReport" based on table "mainTable" functions perfectly in all respects, organized around a single Break Header and single Detail band. A subReport based on table "subTable" functions perfectly within the Detail Band in all respects, EXCEPT that so far, I've been unable to sort its rows. When running Print Report from the Database Explorer, the WHERE clause: ORDER BY breakColumn, detailColumn, subColumn ... fails with a "Column subColumn not found (2369)", as does: ORDER BY breakColumn, detailColumn, subTable.subColumn Alternately, running the PRINT command: PRINT testReport + ARRANGE mainTable BY breakColumn, detailColumn, + ARRANGE subTable BY subColumn + ORDER BY breakColumn, detailColumn, subColumn + OPTION SCREEN ... fails with the same error 2369. Running the PRINT command without reference to subtable and subColumn prints testReport perfectly; but with the un-sorted subReport. It's gotta be simple. What am I missing? Happy 4th! Bruce Bruce A. Chitiea | SafeSectors, Inc. 112 Harvard Ave #272 | Claremont CA 91711-4716 | USA +011 (909) 238-9012 m | [email protected] -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/eme66c9875-9ea5-4617-ae50-550edab29f07%409135c88d.com<https://groups.google.com/d/msgid/rbase-l/eme66c9875-9ea5-4617-ae50-550edab29f07%409135c88d.com?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027B4DB10DC4EE650FF885CD42EA%40BY3PR19MB5027.namprd19.prod.outlook.com.
