Welcome to SPN

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

Sign Up Now!

Help setting up a Report

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

  1. James

    James
    Expand Collapse
    Guest

    I've got a subform that's a table that contains multiple rows of
    records.... I want to have a button where I can generate a report based
    on the rows in that subform. The fields are always the same. Currently,
    I am using statements like:

    =[Forms]![DisplayOfferings]![OfferingsList].[Form]![OfferingCategory]

    to populate the report. However, when I do it like this, it only uses
    the first row of data and doesn't give me the option to scroll through
    the other records. How do I make it so I can use the buttons at the
    bottom of the form to view the other records in the subform?
     
  2. Loading...


  3. Ken Mitchell

    Ken Mitchell
    Expand Collapse
    Guest

    I think you may have the wrong impression of what a report does. I'm no
    expert, (as any of the real experts here will tell you!) but I don't think it
    is possible to have the report re-generate itself on the fly as I believe
    you're asking for.

    Forms are genererally used to display and manipulate data in the Access
    interface. Reports, however, are only used for output. They're used for
    printing and display, not for manipulation

    If I have misunderstood the question, please correct me.

    "James" wrote:

    > I've got a subform that's a table that contains multiple rows of
    > records.... I want to have a button where I can generate a report based
    > on the rows in that subform. The fields are always the same. Currently,
    > I am using statements like:
    >
    > =[Forms]![DisplayOfferings]![OfferingsList].[Form]![OfferingCategory]
    >
    > to populate the report. However, when I do it like this, it only uses
    > the first row of data and doesn't give me the option to scroll through
    > the other records. How do I make it so I can use the buttons at the
    > bottom of the form to view the other records in the subform?
    >
    >
     
  4. James

    James
    Expand Collapse
    Guest

    I don't want the report to be able to regenerate on the fly. I just
    want it to be able to show all the data from my subform (which is a
    table) currently it only shows the first row of data, I don't know how
    to get it so it will generate all the rows of data on seperate pages in
    the report... does that make more since?

    Ken Mitchell (NOSPAM) wrote:
    > I think you may have the wrong impression of what a report does. I'm no
    > expert, (as any of the real experts here will tell you!) but I don't think it
    > is possible to have the report re-generate itself on the fly as I believe
    > you're asking for.
    >
    > Forms are genererally used to display and manipulate data in the Access
    > interface. Reports, however, are only used for output. They're used for
    > printing and display, not for manipulation
    >
    > If I have misunderstood the question, please correct me.
    >
    > "James" wrote:
    >
    > > I've got a subform that's a table that contains multiple rows of
    > > records.... I want to have a button where I can generate a report based
    > > on the rows in that subform. The fields are always the same. Currently,
    > > I am using statements like:
    > >
    > > =[Forms]![DisplayOfferings]![OfferingsList].[Form]![OfferingCategory]
    > >
    > > to populate the report. However, when I do it like this, it only uses
    > > the first row of data and doesn't give me the option to scroll through
    > > the other records. How do I make it so I can use the buttons at the
    > > bottom of the form to view the other records in the subform?
    > >
    > >
     

Share This Page