RE: [sqr-users] print

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

Now I feel dumb for not thinking of a subroutine.  Thanks, Tim.

-----Original Message-----
From: Tim Peters [mailto:timothy.peters@adelaide.edu.au]
Sent: Thursday, June 30, 2005 10:41 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: Re: [sqr-users] print


How about something like this (untested):

begin-procedure print-unless-blank ($str)
   if not isblank($str)
     print $str (+1,1)
   end-if
end-procedure

...

   print $address1 (0,1)
   do print-unless-blank($address2)
   do print-unless-blank($address3)
   ! etc...

Regards,
Tim

radhika reddy wrote:
> Hi,
> 
>   I have to print the in the following format:
> 
> Address1
> Address2
> Address3
> phone
> county    - line by line
> 
> I would do something like this:
> 
> print address1 (0,1)
> print address2 (+1,1)
> print address3 (+1,1)
> print phone (+1,1)
> print county (+1,1)
> 
> My problem is sometimes address2, addr3,phone,county might be empty then 
> there would be 4 lines of space which i don't want to have.
> 
> I don't want to put If statement for each of these to see if they are 
> empty. Is there any better way to do this?
> 
> Thanks. Any help is great.


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users