REMOVING BLANK LINES FOR RECORDS

[NETHROW]

I have a report that has two groups in it. I' trying to get a report that will only print the total for a curency field for each group. The problem that I have is that if a group only has one record in it, they print one group after the other. ti there is more than one record, blank lines are inserted for each record. How do I remove the blank lines and tighten up the report? see example

ACCOUNT 732

Location Avis $100.50
Ford $300.00


Nissan $650.00

Heartz $700.00
Alamo $450.00

ACCOUNT & Location are my groups and as of now I'm performing sums in within the Location header. I also need a runing sum for each ACCOUNT group. When I try to place this in the ACCOUNT footer it gives me 0.00 for each page and a value at the end of the report that only reflects the last record. Any help will be great.
thanx,
nethro

 

[danvlas]

1. You could set the Visible property for the Detail section to No

2. In the Detail section, place a text box for the running sum (let's call it RunSumTextBox). Running Sum: Over Group
In the group footer (or header, whatever) place a textbox with the control source:
=RunSumTextBox

HTH



Daniel Vlas
Systems Consultant
danvlas@yahoo.com