🚀 go-pugleaf

ok here goes.  I have 7 tables.  table 1 had 109 fields, tables 2-6 have 192
fields each, table 7 has 15 fields.  I need to generate a report that
incorporates some or all of each table.  Basically it is a one to many
relationship.  I could generate this report in the ole DOS days but could
never do it under 5.6 so I was going to try again under 7.01.

For each row in table 1 there may be no rows in tables 2-6 OR there may be 1
or more, maybe 100 rows in each of these tables.  Obviously if there are no
rows I want to skip that part of the report, if there are rows they need to
printed out in a table format with each table (2-6) providing a column in
the report.  It gets a bit complex, but if I can't get all the tables and
all the fields into a query (queries???) for the report to use, my pea brain
does not understand how to build the report.  Shoot even if I can get them
visible, I may not figure out how to build the durn thing anyway!

The other table is a lookup table that feeds some info into the report as
well.

If this is not clear enough, I can post a dummy report to show the data
links, but did not want to clutter the group if I did not need to.



Ken Mayer [TeamB] wrote:

> Charlie Lutz <lutzc@mail.wes.army.mil> wrote:
>
> >I tried to use the sql designer (although I think I have read Ken said
> >that is a no-no) and it crashes every time.
>
> Don't use it. Period. <G> Sheesh. How many times do I have to tell you
> this, Charlie?
>
> What exactly are you trying to do? Chances are the SQL builder is
> trying to load the field names for each field (Select field1,field2
> ..) for each table and is freaking itself out.
>
>
>
> If you tell us what you want to do, chances are you can do it directly
> with the OODML objects and can bypass the durn thing completely ...
>
> Ken