Re: End-of-file on SELECT

[Denise White <dewhite@VICR.COM>]

Hi,

Thanks to all who responded to my problem!  In the interest of going with the
most simple solution (all that juggling of before & after procedures does not
qualify, even if it might work - LOL!), the following is how I resolved the two
issues I had:

Per a suggestion from Joy Hoyte, I was able to get the page break to work
correctly by adding a condition checking that the team member was not equal,
while the region was:

      if &v.region_cd = $hold_region and &m.support_team_mbr <> $hold_team_mbr
            new-page
         else
            position                 (+1)
         end-if

Per Nathan's answer, I moved null values to my header variables just before
printing the grand totals.

I knew there had to be simple solutions that I just couldn't see.  That's what's
great about this forum - sometimes you just need another pair of eyes to take a
look and see the obvious.  Everything's working fine now!

Thanks again,
Denise White
Sr. Software Engineer
Vicor