Hello everyone: I have a table that contains three rows. There is a column in the table that allows me to enter an expiration date for any row, thus allowing me to eliminate it from selections etc. if so desired. One of the rows currently has an expiration date the other two rows do not.
I have a report that is connected to said table. I have also defined a variable in the reoport as follows: vCourse = ActNickName in Activities whe ActID = ActID and ExpireDate is NULL The variable is in the display seciton of the report and a break is set on Id number. The reports prints the correct two rows from the table that have no expiration date and a blank row for the row that does have the expiration date. Is there a way to keep the report from printing the blank row? I realize that I can project another temp table with only rows that have no expiration date and then run the report from that table but I was wondering if there was a way to "automatically closeup" the blank spaces on the report. I also know that I might be able to do something like that with the label generator. Any idea's ?
