How do I create a report with multiple 1-M relationships? -

i need create report shows, each master row, 2 sets of child (detail) rows. in database terms can think of table 'a' having 1:m relationship table 'b' , 1:m relationship table 'c'. so, each row table 'a', want display list of child rows 'b' (preferably in 1 section) , list of child rows 'c' (preferably in section). prefer avoid use of sub-reports, if possible. how can best accomplish this?

thanks.

i think understand question correctly, ie given row in table a, want details section(s) show connected rows in table b , connected rows in table c (for number of rows in b or c, including zero). know of 2 solutions this, neither of straightforward.

the first is, you've guessed, disliked subreport option. second involves additional work in database; specifically, creating view combines entries in table b , table c 1 table, can used in main report linkable object report on , can group on table desired. how straightforward depend on how similar structures of b , c are. if identical, view contain simple like

select 'b' detailtype, field1, field2, fieldlinkedtotablea tableb union select 'c' detailtype, field1, field2, fieldlinkedtotablea tablec  

however, neither option scale reports lots of results (unless server supports indexing view).