Bob No need to define the variable. In your print command just use a where clause. Example: print reportname order by columname1 whe columnname2 is not null and your report should print fine. Also I would examine the need for a breakpoint. Unless you're printing one record a page or need sub-totals, there is no need for the breakpoint.
Good luck. Bill Eyring -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bob Powell Sent: Tuesday, November 13, 2001 3:56 PM To: [EMAIL PROTECTED] Subject: R:BASE reporter 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 ?
