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

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

Subject: Re: RE: [sqr-users] array printing challenge
From: Anya Mendenhall <agueniss@gwu.edu>
Date: Wed, 18 Jan 2006 15:34:13 -0500
Delivery-date: Wed, 18 Jan 2006 15:36:28 -0500
In-reply-to: <20060118202554.KCEJ1595.tomts46-srv.bellnexxia.net@[209.226.175.82]>
List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Priority: normal
References: <20060118202554.KCEJ1595.tomts46-srv.bellnexxia.net@[209.226.175.82]>

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
> > > 
> > 
> > 
>

Here was a non admissible message part of 'text/x-vcard' MIME type. It
has been automatically discarded before sending the message to the
list.

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

Follow-Ups:
- Re: RE: [sqr-users] array printing challenge
  - From: "kyle.leonard" <kyle.leonard@1answersolutions.com>
- Re: RE: [sqr-users] array printing challenge
  - From: Daniel Vandenberg <vandberg@uwosh.edu>

References:
- Re: RE: [sqr-users] array printing challenge
  - From: <bmrazek@sympatico.ca>

Prev by Date: Re: RE: [sqr-users] array printing challenge
Next by Date: RE: RE: [sqr-users] array printing challenge
Previous by thread: Re: RE: [sqr-users] array printing challenge
Next by thread: Re: RE: [sqr-users] array printing challenge
Indexes: [ Thread] [ Author] [ Date]
SQR-USERS List and Archive Info
SQRUG Home Page