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

["Knapp, Richard" <KnappR@umsystem.edu>]

But all the names can't print on the same line.  So you are going to
have to count characters and construct some logic to handle the
printing.

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 2:34 PM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: Re: RE: [sqr-users] array printing challenge

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