Re: RE: [sqr-users] array printing challenge

["PeterG Clark" <PeterG.Clark@vac-acc.gc.ca>]

Anya,

Your problem is related to the fact that there are no spaces between your table 
entries (I think ... it is hard to tell from your examples). The Wrap sees no 
place to perform a logical wrap so it goes to the maximum character count you 
have specified before wrapping.

If your entries had a space between them, the wrap command would perform as you 
are expecting it to.


For instance, a value of "12345123451234512345" on a WRAP 13 2 would print as:
1234512345123
4512345

This seems to be the problem you are having, no?


But a value of "12345 12345 12345 12345" on the same wrap (WRAP 13 2) would 
print as:
12345 12345
12345 12345

It shouldn't be any problem for you to add a space to each array entry as you 
are building your array. 

Hope this helps.

>>> agueniss@gwu.edu 2006/01/18 16:34:13 >>>
I guess I was not very clear. I want all of the names to print on the 
same line. However, when the printing gets to a name and it is the end 
of the line, I need this name to be printed on the next line. So if I 
have my array as follows:


    Gallo|Y| Sarrafzdeh| Medghalchi| Swan| Shibata| Daryabandari| 
Turkkan| Almarmoom| Liebes| Alhussaini| Bushkrs
kilo| Bob| 

I need Bushkrskilo| to be printed on the new line, so that it looks 
like this:

Gallo|Y| Sarrafzdeh| Medghalchi| Swan| Shibata| Daryabandari| Turkkan| 
Almarmoom| Liebes| Alhussaini| 
Bushkrskilo| Bob| 




********************************************        
  Anya Mendenhall
  Enterprise Resource Planning Developer   
  Information Systems & Services
  The George Washington University
  44983 Knoll Square, Ste 380,
  Ashburn, Virginia 20147
  Tel No: 703-726-1970
  Fax No: 202-994-5251
********************************************         


----- Original Message -----
From: bmrazek@sympatico.ca 
Date: Wednesday, January 18, 2006 3:30 pm
Subject: Re: RE: [sqr-users] array printing challenge
To:  "This list is for discussion about the SQR database reporting
        language        from Hyperion Solutions." <sqr-users@sqrug.org>

> Removing the comman fixed your wrap error.  All your names are 
> printing on the same line because you are not increasing your line 
> positon in the print command.
> 
> Example: print &name (+1, 20) bold
> 
> +1 says print on the next line, 20 is the column position to start 
> the print.
> 
> 
> > 
> > From: Anya Mendenhall <agueniss@gwu.edu>
> > Date: 2006/01/18 Wed PM 03:12:43 EST
> > To: "This list is for discussion about the SQR database reporting
> >     language from Hyperion Solutions." <sqr-users@sqrug.org>
> > Subject: Re: RE: [sqr-users] array printing challenge
> > 
> > comma is removed, names still wrap..
> > 
> > ********************************************        
> >   Anya Mendenhall
> >   Enterprise Resource Planning Developer   
> >   Information Systems & Services
> >   The George Washington University
> >   44983 Knoll Square, Ste 380,
> >   Ashburn, Virginia 20147
> >   Tel No: 703-726-1970
> >   Fax No: 202-994-5251
> > ********************************************         
> > 
> > 
> > ----- Original Message -----
> > From: Peter Burton <Peter_Burton@hyperion.com>
> > Date: Wednesday, January 18, 2006 3:11 pm
> > Subject: RE: [sqr-users] array printing challenge
> > To:  "This list is for discussion about the SQR database 
> > reportinglanguage from      Hyperion Solutions." <sqr-
users@sqrug.org>
> > 
> > > 
> > > SQR is issuing the error because you have a comma after the 
> 80.  
> > > Removethe comma.
> > > 
> > > Peter
> > > 
> > > -----Original Message-----
> > > From: sqr-users-bounces+peter_burton=hyperion.com@sqrug.org 
> > > [mailto:sqr-users-bounces+peter_burton=hyperion.com@sqrug.org] 
> On 
> > > BehalfOf Knapp, Richard
> > > Sent: Wednesday, January 18, 2006 3:00 PM
> > > To: This list is for discussion about the SQR database 
> > > reportinglanguagefromHyperion Solutions.
> > > Subject: RE: [sqr-users] array printing challenge
> > > 
> > > 
> > > I think this is a print challenge rather than an array 
> challenge.  
> > > Whatrow(s) do you imagine these array elements are being 
> printed on?
> > > 
> > > Richard Knapp
> > > Database Programmer/Analyst
> > > Institutional Research and Planning
> > > University of Missouri System
> > > 573-882-8856
> > > knappr@umsystem.edu 
> > > 
> > > -----Original Message-----
> > > From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org 
> > > [mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On 
> Behalf Of
> > > Anya Mendenhall
> > > Sent: Wednesday, January 18, 2006 1:45 PM
> > > To: sqr-users@sqrug.org 
> > > Subject: [sqr-users] array printing challenge
> > > 
> > > 
> > > Array challenge
> > > 
> > > Ok, I am not sure if this is possible in SQR. I have an array 
> of 
> > > students that can store up to 16 names. I have defined my 
> array as 
> > > follows:
> > > 
> > > create-array name=instr_arr size=100  field=last_name:char
> > > 
> > > When I put values into my array, I actually concatenate 
> students  
> > > name 
> > > along with a | and a certain indicator. So a value in my array 
> > > might 
> > > look like this:
> > > 
> > > Liang|Y|
> > > Jenn Doe|Y| Anna Smith|Y
> > > Todd Bond|Y| Joe Shmoe| 
> > > 
> > > The problem is that when I print out this array and the array 
> has 
> > > a lot 
> > > of names in it, the names wrap so that one part of the name is 
> on 
> > > one 
> > > line and the other part of the name is on the other line. Here 
> is 
> > > an 
> > > example:
> > > 
> > >                   Gallo|Y| Sarrafzdeh| Medghalchi| Swan| 
> Shibata| 
> > > Daryabandari| Turkkan| Almarmoom| Liebes| Alhussaini| Bush| Vande
> > > rhoek| Almidfa| Khan| Ahmadi-Sabet|
> > > 
> > > Do you see  how Vanderhoek wraps around? How do I go about it? 
> I 
> > > need 
> > > to figure out if I am at the end of the line and go to the 
> next? I 
> > > tried the wrap command, but it does not work, as I get the 
> > > following 
> > > error:
> > > 
> > > Error on line 287:
> > >   (SQR 5304) Qualifier 'wrap' requires a numeric literal, 
> > > variable, or 
> > > column.
> > >      print $instr_name (,+1) wrap 80, 2
> > > 
> > > Here is my code:
> > > 
> > > while #ind < {maxArraySize}
> > >    let $instr_name = instr_arr.last_name(#ind)
> > > 
> > >    if ($flag = 'N')
> > >      print $instr_name (,4,15)
> > >    else
> > >      print $instr_name (,+1) wrap 80, 2 - this wrap command 
> does 
> > > not 
> > > work
> > >    end-if
> > > 
> > >    let $flag = 'Y'
> > >    add 1 to #ind
> > > 
> > >  end-while
> > > 
> > > 
> > > Any ideas on how to go about this? Thank you!
> > > ********************************************        
> > >  Anya Mendenhall
> > >  Enterprise Resource Planning Developer   
> > >  Information Systems & Services
> > >  The George Washington University
> > >  44983 Knoll Square, Ste 380,
> > >  Ashburn, Virginia 20147
> > >  Tel No: 703-726-1970
> > >  Fax No: 202-994-5251
> > > ********************************************         
> > > 
> > > 
> > > _______________________________________________
> > > 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