I have a few different report scenarios where I would like to eliminate the printing of blank lines.
I tried Razzak's example in one of the "From the Edge" articles using IFEXISTS and IFNULL.
This solved part of the problem but created another.
Using Razzak's example from the article. It is a name/address scenario with five detail lines
however there are situations where 3, 4, or 5 lines print. Using IFEXISTS and IFNULL works
perfectly to have the proper number of lines print with appropriate data in them.
The problem in my reports is that I now have an inconsistent gap between the end of the 3 or
4 line print and the next address of 3,4, or 5 lines of data.
Assuming others have been faced with this, how does one eliminate the now additional blank
lines and get the spacing between addresses consistent regardless of the number of lines
that printed.
TIA,
Ed
