| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 55669 | 2005-03-16 19:30:00 | MS Works Suppress Lines in Report | allisonmarie (7613) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 334765 | 2005-03-16 19:30:00 | I can't remember how to suppress lines in a report (MSWorks) when the data entry is blank. Do you know how?? |
allisonmarie (7613) | ||
| 334766 | 2005-03-16 20:08:00 | Hi there. Make yourself a filter - Tools/Filters. As the Field Name select a field that every record must have, such as Surname. Under Comparison, select "is not blank". ;) | Scouse (83) | ||
| 334767 | 2005-03-16 21:16:00 | I created a filter but the blank lines still are there in the print preview. | allisonmarie (7613) | ||
| 334768 | 2005-03-16 22:59:00 | Hi again. Is your report incorporating the filter? I'll get bck to you this evening re the other matter. Will be out all day. ;) |
Scouse (83) | ||
| 334769 | 2005-03-17 08:42:00 | Hi am. To suppress lines in report where a data field is blank.... Works 4.5 Tools, Report Creator, name Report, from the DB Fields available, select those you want in the report. Set your Sort and then Create New Filter. (If you already have 8 filters you will need to delete or modify and reuse an existing one.) In Filter, select the Field Name which you know will be blank in the records you don't want. Comparison = is not blank. Then View, Report, ensure that your choice of reports is highlighted/selected and Preview. If you Cancel the view, you will then have the opportunity to cosmetically modify the layout and appearance of the report skeleton. Note, if you just want to eliminate any blank lines which contain no actual records, in Filter select the field which every record must have, such as ID Number, Surname, Stock Number, etc., and Comparison = is not blank. :cool: |
Scouse (83) | ||
| 1 | |||||