Why, so it does. Thanks, Dan. Happy 4th!
Bruce
------ Original Message ------
From "Dan Goldberg" <[email protected]>
To "[email protected]" <[email protected]>
Date 7/4/2023 4:13:34 PM
Subject Re: [EXTERNAL] [RBASE-L] - SubReport Sorting Fail
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
<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/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
<https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027B4DB10DC4EE650FF885CD42EA%40BY3PR19MB5027.namprd19.prod.outlook.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/emc562fe96-0bd9-4626-8aeb-835b255ad3d9%409135c88d.com.
