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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/eme66c9875-9ea5-4617-ae50-550edab29f07%409135c88d.com.
