[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] blank line being inserted unexpectedly whileissuingprint commands
- Subject: Re: [sqr-users] blank line being inserted unexpectedly whileissuingprint commands
- From: "Larry Roux" <lroux@syr.edu>
- Date: Mon, 11 Apr 2005 21:41:21 -0400
- Delivery-date: Mon, 11 Apr 2005 20:42:13 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
It appears that you are still printing a line in your loop, but the
variable is coming out a space so you don't see the results. As a
method of debugging try something like
Let $var = $var || ' row: ' || some data from the row
that might tell you which row is still printing.
also, instead of blanking out the variable (Let $var = ' ') try putting
something in there to see if that is, in fact, what is happening.
Larry Roux
Syracuse University
lroux@syr.edu
>>> fromthehills@gmail.com 04/11/05 9:27 PM >>>
Hello All -
You've been super helpful to me in the past, and I've got another
problem that has me stumped.
I am writing a report that selects a row of data from a table and
based on the data in that row, it may decide to omit the line from the
report.
So let's say I have table:
row 1 - a1
row 2 - a2
row 3 - a3
row 4 - b1
row 5 - b2
row 6 - b3
row 7 - c1
row 8 - c2
row 9 - c3
And I know that, based on the content of row 5 (b2) that I want to
omit rows 4-6 (the b's). I've got the logic working so that all three
rows are omiitted, but for some reason the output is:
a1
a2
a3
c1
c2
c3
and not:
a1
a2
a3
c1
c2
c3
I'm just using a basic "print $var (+1,1)" command and have been
through the code about a million times to see if I might have an extra
"print" statement in my exclusion processing, but I can't find
anything.
Has anyone encountered anything like this? Any suggestions of things
to check that could cause this?
Thanks!
Marc
_______________________________________________
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