I had to do the same thing. The way I did it was to take
the 2 'many' tables (I actually had up to 4 of them!) and
load the data into a temp table with a single column used
as a break indicator. This assumes that the data in the 2
tables could reasonably fit into the same columns and appear
on the report in the same place. So Client's Children could
go in as:
ClientID1 Baby Bob 1
ClientID1 Sister Sue 1
while Client's Organizations could go in as:
ClientID1 Company1 2
ClientID1 Company2 2
Your report could break on the ClientID column, then the
second break would be on the flag column (the 1 or 2 above).
Data from the 'main' table would be lookups based on the
clientid.
Karen
I need to create a report where data will come from a main table and two
additional tables that have a many-to-one relationship with the main table.
This is easy to do with only one Many table involved, but with two (or more)
I'm looking for an easier way to do it than doing a bunch of processing of
the data.
Is there a SQL command or View that can be established to make this easy?
