Welcome to SPN

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

Sign Up Now!

Is it possible to print details horizontally in a report?

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

  1. NB

    NB
    Expand Collapse
    Guest

    I have a report that lists the grades of students. Other than making each
    assignment it's own field, is there a way to have Access reflect the records
    horizontally?

    e.g. Instead of:
    A
    A
    B
    A

    I'd like it to show the records horizontally:
    A A B A
     
  2. Loading...

    Similar Threads Forum Date
    Movies Ashdoc's movie review---Mission impossible 5 Rogue nation Theatre, Movies & Cinema Aug 12, 2015
    India Professor Bhullar's release possible after landmark SC judgement Breaking News Jan 21, 2014
    USA UPDATED! Dr. Prabjot Singh, Sikh Professor Attacked in Possible Hate Crime (2 Videos) Breaking News Sep 23, 2013
    A Shabad I came across - possible interpretations Sikh Sikhi Sikhism Aug 28, 2013
    To know God is to Love him, why this is not possible Sikh Sikhi Sikhism Mar 31, 2012

  3. Ken Sheridan

    Ken Sheridan
    Expand Collapse
    Guest

    There are two ways you can do this. The first is to control the layout as
    the report is formatted at runtime with code in the reports module. A much
    simpler way, however is to put a multi columned subreport in the detail
    section. The parent report can be based on a Students table or on a query
    which joins this to other table(s) on which you restrict the students
    returned in the query. If the latter include only the student's details in
    the query's result table and use a SELECT DISTINCT query so only one row per
    student is returned.

    The subreport will be based on a query which returns the grades per student.
    On the Columns tab of the dialogue opened with File|Page Setup in report
    design view set up the subreport with as many columns as will fit across the
    page , or that part of the page you want to list the grades on, page and of
    an appropriate column width. Set the column layout to 'across then down'.

    In the main parent report link the subreport to the parent report on the
    unique identifier for each student, such as StudentID.

    When the parent report prints the grades for each student will be printed
    across the page. If the right margin is reached the next grade for that
    student will print below the first one as a second row.

    I've posted a demo of both methods at the link below, which uses club
    membership data, but the principle is exactly the same:

    http://community.netscape.com/n/pfx...yMessages&tsn=1&tid=24271&webtag=ws-msdevapps


    Ken Sheridan
    Stafford, England

    "NB" wrote:

    > I have a report that lists the grades of students. Other than making each
    > assignment it's own field, is there a way to have Access reflect the records
    > horizontally?
    >
    > e.g. Instead of:
    > A
    > A
    > B
    > A
    >
    > I'd like it to show the records horizontally:
    > A A B A
     
  4. NB

    NB
    Expand Collapse
    Guest

    Thank you Ken. This will work!

    NB

    "Ken Sheridan" wrote:

    > There are two ways you can do this. The first is to control the layout as
    > the report is formatted at runtime with code in the reports module. A much
    > simpler way, however is to put a multi columned subreport in the detail
    > section. The parent report can be based on a Students table or on a query
    > which joins this to other table(s) on which you restrict the students
    > returned in the query. If the latter include only the student's details in
    > the query's result table and use a SELECT DISTINCT query so only one row per
    > student is returned.
    >
    > The subreport will be based on a query which returns the grades per student.
    > On the Columns tab of the dialogue opened with File|Page Setup in report
    > design view set up the subreport with as many columns as will fit across the
    > page , or that part of the page you want to list the grades on, page and of
    > an appropriate column width. Set the column layout to 'across then down'.
    >
    > In the main parent report link the subreport to the parent report on the
    > unique identifier for each student, such as StudentID.
    >
    > When the parent report prints the grades for each student will be printed
    > across the page. If the right margin is reached the next grade for that
    > student will print below the first one as a second row.
    >
    > I've posted a demo of both methods at the link below, which uses club
    > membership data, but the principle is exactly the same:
    >
    > http://community.netscape.com/n/pfx...yMessages&tsn=1&tid=24271&webtag=ws-msdevapps
    >
    >
    > Ken Sheridan
    > Stafford, England
    >
    > "NB" wrote:
    >
    > > I have a report that lists the grades of students. Other than making each
    > > assignment it's own field, is there a way to have Access reflect the records
    > > horizontally?
    > >
    > > e.g. Instead of:
    > > A
    > > A
    > > B
    > > A
    > >
    > > I'd like it to show the records horizontally:
    > > A A B A

    >
     

Share This Page