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

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

Subject: Re: RE: RE: [sqr-users] array printing challenge
From: Anya Mendenhall <agueniss@gwu.edu>
Date: Wed, 18 Jan 2006 16:19:24 -0500
Delivery-date: Wed, 18 Jan 2006 16:21:46 -0500
In-reply-to: <C3A8BF882E6B604B8DFA11DDD25D2226017AA68D@UM-EMAIL05.um.umsystem.edu>
List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Priority: normal
References: <C3A8BF882E6B604B8DFA11DDD25D2226017AA68D@UM-EMAIL05.um.umsystem.edu>

yep. that is why I asked the question..Not sure about the logic ..

********************************************        
  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: "Knapp, Richard" <KnappR@umsystem.edu>
Date: Wednesday, January 18, 2006 4:10 pm
Subject: RE: RE: [sqr-users] array printing challenge
To:  "This list is for discussion about the SQR database 
reportinglanguage from  Hyperion Solutions." <sqr-users@sqrug.org>

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

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: [sqr-users] array printing challenge
  - From: Melody Sayles <Melody.Sayles@alaska.edu>

References:
- RE: RE: [sqr-users] array printing challenge
  - From: "Knapp, Richard" <KnappR@umsystem.edu>

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