RE: [sqr-users] print

["Steve Cavill" <steve.cavill@infoclarity.com.au>]

If the fields are empty, rather than containing blanks,
Maybe next-listing no-advance would help?
(I haven't tested that)
Steve.

-----Original Message-----
From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org
[mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org] On Behalf 
Of Alexander, Steve
Sent: Friday, 1 July 2005 9:18 AM
To: 'This list is for discussion about the SQR database reportinglanguagefrom 
Hyperion Solutions.'
Subject: RE: [sqr-users] print

I don't blame Radhika for looking for another way.  It's frustrating to have to 
repeat the same concept to the compiler over and
over.  It would be nice if SQR had a conditional print statement that only 
advanced the position pointer and printed a variable if
that variable weren't null.  Even if the address lines were in an array, the 
loop would be awkward because the print statement
doesn't take array elements.

-----Original Message-----
From: Bob Stone [mailto:bstone@fastenal.com]
Sent: Thursday, June 30, 2005 2:47 PM
To: 'This list is for discussion about the SQR database reporting languagefrom 
Hyperion Solutions.'
Subject: RE: [sqr-users] print


Good word, Steve: verbose.

I think Steve's right...the easiest way to do it is with an IF statement for 
each of them.  Not just easiest to write, but also
easiest to follow. The if statements won't slow up the program any noticeable 
amount...I'm not sure why you would want to find a
harder way to do it??  Just because it's the 'easy way' doesn't mean it's not 
also smart, good programming.

-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of Alexander, 
Steve
Sent: Thursday, June 30, 2005 3:45 PM
To: 'This list is for discussion about the SQR database reportinglanguage from 
Hyperion Solutions.'
Subject: RE: [sqr-users] print


I can think of other ways to handle this, but they're all more complex and 
verbose than putting each print in an IF statement.

-----Original Message-----
From: radhika reddy [mailto:radhika_05@hotmail.com]
Sent: Thursday, June 30, 2005 1:30 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] print


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.

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/


_______________________________________________
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

_______________________________________________
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