Bill,
Think about the exact mechanism and the logic used in Multi-Table RBG7,
RBG75 and RBG8 Form Designer. The exact same data retrieval and linking
logic is used in Master/Slave (Sub-Reports).
Here's are a few pointers:
01. Many-To-Many relationship model is used in Master/Slave (Sub-Reports)
02. WHERE clause applies to the Master (Main) table only
03. Use ARRANGE BY clause to sort/order the matching rows in Slave
Table(s) as traditionally used in Multi-Table forms
Hope that helps!
Very Best R:egards,
Razzak.
At 04:55 PM 8/24/2005, Bill Downall wrote:
Thanks, Razzak, for a really nice document to help understand all these
details!
One more feature that I would like more help understanding is the master
table/slave table relationships. How is data in the subreport table or
view linked to data in the master table/view? How do I have control over
the equivalent of a WHERE clause for the slave table? How do I do the
equivalent of an ORDER BY clause for the sub-report/slave table?
Searching for "slave" in the help files and in the FTE documents I have
downloaded didn't help me.
Thanks.
Bill
A. Razzak Memon wrote:
>
> Wednesday, August 24, 2005
>
> From the Edge: Understanding Sub-Reports
> Section: Reports and Report Designer
> Chapter: Running R:BASE Your Way!
> Platform: R:BASE 7.5 and V-8 "Turbo" for Windows
> Builds: R:BASE 7.5 (7.5.11.30720 or higher)
> R:BASE V-8 "Turbo" (8.0.9.30720 or higher)
>
