Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Aug 2002
    Location
    Wichita, Kansas, USA
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Print Report Totals but not Detail section (2003)

    I have a report that is calculating a running sum, via VBA. The header has the beginning balance. The detail section has the adjustment amounts and the "Detail - on Print event" does the running balance calculation. The "Footer on Print event" picks up the last balance and prints it. This is all working fine and printing correctly for the report where I need the detail displayed.

    I need to use the same report but only show the ending balance, not show the detail. I have set the "height = 0" on the controls and the "detail section" and the "header section". I have set the same controls and sections "can shrink = yes". I tried setting the detail section's "visible = no", but then it doesn't do the running balance calculation, it just skips it.

    Just another point of information - but it shouldn't affect the answer you give me -- I have the detail report hooked with a parameter query asking for a particular account type that it will print for. The summary report will be for all account types.

    I've searched through a lot of Woody's and Microsoft, but am not finding anything. Maybe I'm not entering the correct search words.

    Can somebody please help?

    Thanks so much
    Patty

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Print Report Totals but not Detail section (2003)

    What happens if you
    - Set the Can Shrink property of all text boxes in the Detail section and of the Detail section itself to Yes.
    - Set the Visible property of all text boxes in the Detail section to No, but leave the Visible property of the Detail section to Yes.

  3. #3
    Star Lounger
    Join Date
    Aug 2002
    Location
    Wichita, Kansas, USA
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print Report Totals but not Detail section (2003)

    That is how I have it set now and it still leaves blank lines between each account type. There is a different amount of blank lines between the different acount types, so I assume it depends on how many records there are in the detail section being used for calculating.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Print Report Totals but not Detail section (2003)

    Push all text boxes up against the top of the Detail section (by setting their Top property to 0), and then drag the bottom of the detail section up as far as it will go.

  5. #5
    Star Lounger
    Join Date
    Aug 2002
    Location
    Wichita, Kansas, USA
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print Report Totals but not Detail section (2003)

    We're getting closer!

    I can't have the Top=0 and the Height=0 or it doesn't use the numbers in that section for the calculations. It skips them just like it does when I hide the section.

    But, if I set Height = .0007 (the smallest it would let me other than 0) and the Top = 0 OR Height = 0 and Top = .0007, the report is real close. There are only a couple of account types that have a little more blank space between them than single spacing. I think this report is only for internal dept use and all accounts now fit on one page, so I will see if it is usable enough for them.

    Thanks so much for your help!
    Patty

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Print Report Totals but not Detail section (2003)

    In a test report, the height of the controls didn't matter, as long as there was no blank space above or below them, i.e. they fitted tightly in the detail section. Setting Can Shrink = Yes and Visible = No made the entire detail section disappear, even with hundreds of detail records, while calculations were still performed correctly.

Posting Permissions

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