[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] print




Thanks to all. I finally decided to have If statements. I wanted to have a 
second opinion on this which i always get from this group.

Thanks again.


>From: "Peter Burton" <Peter_Burton@hyperion.com>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "This list is for discussion about the SQR database reportinglanguage 
>fromHyperion Solutions." <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] print
>Date: Fri, 1 Jul 2005 11:59:37 -0400
>
>Tim,
>
>However using a routine is a lot slower than just putting the "if" around 
>the print and it also makes assumptions about the print itself (location, 
>attributes, etc.).
>
>Peter
>
>-----Original Message-----
>From: sqr-users-bounces+peter_burton=hyperion.com@sqrug.org
>[mailto:sqr-users-bounces+peter_burton=hyperion.com@sqrug.org]On Behalf
>Of Alexander, Steve
>Sent: Friday, July 01, 2005 11:54 AM
>To: 'This list is for discussion about the SQR database
>reportinglanguagefrom Hyperion Solutions.'
>Subject: RE: [sqr-users] print
>
>
>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
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/


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