Print Report Totals but not Detail section (2003)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote