Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    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)

  3. #3
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    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?

  5. #5
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am sorry - I will try better.

    Main report is as follows:


    ____________Report__NAME___________ xxx(Page Header)

    ________________________CityA__CityB__CityC___Tota lxxx(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.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Page headers and footers of subreports are ignored - they will *not* be displayed or printed.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Perhaps the topic Report with two sub-reports from earlier this week will help.

  8. #8
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •