At 03:08 PM 6/6/2013, Patti Jakusz wrote:
I am having a hard time with sorting data in a subreport. I have a report
that lists clients, then a subreport that lists dates of visits with the
client. I went to Breaks on the subreport and selected my visit date
column and said to sort it, ascending. But it doesn't. They are listed
on the report in the order they appear in my table. Is there something
else I'm supposed to do?
I'm using 9.5 and Win XP.
Use the ARRANGE BY clause to sort sub-report.
If you have a form with slave tables and a report with sub-reports,
and if you wish to sort the matching rows related to slave table(s)
/sub-report(s), you'll need to use the ARRANGE BY clause to achieve
your goal.
ARRANGE tablename BY columnlist sorts the rows displayed by a form's
or report's lower-level tables. Each lower-level table in the form or
report that you want to sort requires its own ARRANGE clause. You can
specify up to twenty-five tables to ARRANGE and up to five columns in
each table on which R:BASE will sort.
-- Example 01 (Forms with Slave Tables)
Database: RRBYW18
Sample Form: SalesTransactions
Associated Tables (5):
. Customer (Master)
. InvoiceHeader (Slave 1)
. InvoiceDetail (Slave 2)
. Employee (Slave 3)
. Contact (Slave 4)
Command:
-- Begin
EDIT USING SalesTransactions +
ARRANGE InvoiceHeader BY TransID, +
ARRANGE InvoiceDetail BY ItemNum, +
ARRANGE Employee BY EmpLName,EmpFName +
ARRANGE Contact BY ContLName,ContFName +
WHERE CustState = 'CA' ORDER BY Company
RETURN
-- End
Example 02: (Reports and Sub-Reports)
Database: RRBYW18
Sample Report with Sub-Report: CustomerContacts
Associated Tables (2):
. Customer (Master)
. Contact (Slave 1)
Command:
-- Begin
PRINT CustomerContacts +
ARRANGE Contact BY ContLName,ContFName +
ORDER BY Company WHERE CustState = 'CA' +
OPTION SCREEN|WINDOW_STATE MAXIMIZED +
|ZOOM_TYPE PERCENTAGE|ZOOMPERCENT 90
RETURN
-- End
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
30+ years of continuous innovation!
15 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
