Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

KBV - Reports

Discussion in 'Information Technology' started by KBV, Jul 28, 2006.

Tags:
  1. KBV

    KBV
    Expand Collapse
    Guest

    Does each report always represent either ONE table OR query? Can it ever
    represent more than one query (for example, a form can also have a subform
    and therefore it can represent more than one table/query at a time).

    Thanks
     
  2. Loading...


  3. Debra Farnham

    Debra Farnham
    Expand Collapse
    Guest

    Just like a form can have a subform, a report can have a subreport.

    I hope that's what you were asking.

    Debra

    "KBV" <KBV@discussions.microsoft.com> wrote in message
    news:F0A66AAB-52CF-4425-9166-20020798530D@microsoft.com...
    > Does each report always represent either ONE table OR query? Can it ever
    > represent more than one query (for example, a form can also have a subform
    > and therefore it can represent more than one table/query at a time).
    >
    > Thanks
     
  4. david epsom dot com dot au

    david epsom dot com dot au
    Expand Collapse
    Guest

    A form can also have a header, a detail section, and a footer.

    A report can have multiple header and detail sections.

    So you can multiple tables represented like this

    table 1
    table 2
    table 3
    table 3
    table 2
    table 2
    table 3
    table 1
    table 1
    table 2
    table 3

    That covers 90 percent of all requirements

    Sometimes you want the same tables, grouped differently.
    Subreports are useful for that:

    table 1
    table 2
    table 3
    table 2
    table 1

    table 3
    table 2
    table 3


    That covers the other 10 percent of all requirements.

    You can also have union queries, so multiple
    tables can be represented like this:

    table 1
    table 3
    table 2
    table 3
    table 1
    table 3
    table 2
    table 3

    That is only required if you have badly designed data.

    You can also use subreports to report unrelated data:

    table 1

    table 2

    table 3

    Like union queries, this is only required if you have
    badly designed data.

    (david)


    "KBV" <KBV@discussions.microsoft.com> wrote in message
    news:F0A66AAB-52CF-4425-9166-20020798530D@microsoft.com...
    > Does each report always represent either ONE table OR query? Can it ever
    > represent more than one query (for example, a form can also have a subform
    > and therefore it can represent more than one table/query at a time).
    >
    > Thanks
     

Share This Page