You need a WHERE clause on your PRINT command Print report WHERE date is NULL
"Bill Eyring" <[EMAIL PROTECTED]> wrote: > > >-----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 ? > > > > -- __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
