Arrange by is used with subtables and order by is used by maintable
Dan Goldberg ________________________________ From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> on behalf of Bruce Chitiea <rby...@safesectors.com> Sent: Tuesday, July 4, 2023 3:39:12 PM To: rbase-l@googlegroups.com <rbase-l@googlegroups.com> 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 | rby...@safesectors.com -- 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 rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>. 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 rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027B4DB10DC4EE650FF885CD42EA%40BY3PR19MB5027.namprd19.prod.outlook.com.