• 2 SUBs in Report Footer

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » 2 SUBs in Report Footer

    • This topic has 7 replies, 2 voices, and was last updated 16 years ago.
    Author
    Topic
    WSMS_fan
    AskWoody Lounger
    April 2, 2009 at 12:26 pm #458803

    I have to have 2 sub reports at the end of the report.
    I have inserted both into Report footer. However they do not keep the format.
    Also Second one have to start from a new page but it starts after the first one and it looks wrong.

    I am not sure what to do, please, advise. Thanks

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSHansV
      AskWoody Lounger
      April 2, 2009 at 2:02 pm #1154836

      What do you mean by “they do not keep the format”?

      You can insert a Page Break control between the first and second subreports (the Page Break control is available on the Toolbox)

      Reply | Quote
      • WSMS_fan
        AskWoody Lounger
        April 2, 2009 at 2:49 pm #1154843

        Here is what is happening.

        Report has a Page Header:

        ____________Report__NAME___________

        _____________ColA__ColB__ColC___Total

        ********Data etc….

        Report_Footer has 2 SUB Reports with Page Headers:

        ____________Report__NAME___________

        _____________CityColA__CityColB__CityColC___Total

        ********Data etc….

        AND

        ____________Report__NAME___________

        _____________SumColA__SumColB__SumColC___Total

        ********Data etc….

        So – Report names are the same – headers for the column s are differentfor each.

        When I am printing – Main Report’s Page Headers appearing on SUB Reports.
        I had tried to set RH to Not with Rpt Hdr – this way nothing gets printed for SUBS.

        I am playing with different options and none seem works. I am sure I am overlooking one that is correct one.
        I hope there is one, thank you.

        P.S. Desired outcome is each of 3 Reports showing same Report name and different headers per each. Every Report has more then 1 page. Thanks

        Reply | Quote
        • WSHansV
          AskWoody Lounger
          April 2, 2009 at 3:47 pm #1154850

          I don’t understand your description, but wouldn’t it be better to print the three reports separately instead of trying to cram everything into one report?

          Reply | Quote
          • WSMS_fan
            AskWoody Lounger
            April 2, 2009 at 4:01 pm #1154852

            I am sorry – I will try better.

            Main report is as follows:

            ____________Report__NAME___________ xxx(Page Header)

            ________________________CityA__CityB__CityC___Totalxxx(Page Header)

            Countryxxx(Group Header)___x_____x______x________x

            Totalxxx(Group Footer)______x_____x______x________x

            SUB Report1xxx(Report Footer)

            Body of the Sub Report :

            ____________Report__NAME___________ xxx(Page Header)

            _____________________Totalxxx(Page Header)

            Citiesxx(Group Header)___x

            Totalxxx(Group Footer)___x

            _____________________________________________________

            So the SUB Report is the summary of the Main.
            It is one Report with 2 SUBs that are different cuts anf totals of the Main.

            Reply | Quote
            • WSHansV
              AskWoody Lounger
              April 2, 2009 at 4:17 pm #1154853

              Page headers and footers of subreports are ignored – they will *not* be displayed or printed.

              Reply | Quote
            • WSHansV
              AskWoody Lounger
              April 2, 2009 at 4:45 pm #1154861

              Perhaps the topic Report with two sub-reports from earlier this week will help.

              Reply | Quote
            • WSMS_fan
              AskWoody Lounger
              April 3, 2009 at 8:37 am #1154953

              WOW!
              It is amazing!
              Hans, how do you know all this???
              I just told my boss it is impossible but I have last resort…

              THANKS SO MUCH

              Reply | Quote
    Viewing 0 reply threads
    Reply To: 2 SUBs in Report Footer

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    April 2025
    S M T W T F S
     12345
    6789101112
    13141516171819
    20212223242526
    27282930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.