[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: "Bob Helm" <Bob.Helm@mediware.com>
Date: Fri, 20 Jan 2006 10:34:14 -0600
Delivery-date: Fri, 20 Jan 2006 11:36:47 -0500
List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Thread-index: AcYdE9gBIMxHeTc1TuqB7aXvBC0apQAy3iQA
Thread-topic: RE: RE: [sqr-users] array printing challenge
It occurred to me that you might double check the declare-layout section. 
Perhaps the report width isn't wide enough?

-----Original Message-----
From: sqr-users-bounces+bob.helm=mediware.com@sqrug.org
[mailto:sqr-users-bounces+bob.helm=mediware.com@sqrug.org]On Behalf Of
Anya Mendenhall
Sent: Thursday, January 19, 2006 10:14 AM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: Re: RE: RE: [sqr-users] array printing challenge


yes, that is exactly what I need. Thank you all for the help, I am 
still working on it :(

btw - I am she :)

********************************************        
  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: PeterG Clark <PeterG.Clark@vac-acc.gc.ca>
Date: Thursday, January 19, 2006 10:58 am
Subject: RE: RE: [sqr-users] array printing challenge
To: sqr-users@sqrug.org

> Unfortunately, that would give Anya one name per line and I don't 
> think that is what he is looking for ... I think he just wants as 
> many names as will fit within his 80 columns but will break on a 
> full word rather than in the middle of a word, no?
> 
> >>> Peter_Burton@hyperion.com 2006/01/19 09:45:35 >>>
> Anya,
> 
> You can tell the PRINT WRAP function what character to break on, for
> example
> 
>       PRINT $Value (#row, #Col) Wrap 80 2 On='|' 
> 
> 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 PeterG Clark
> Sent: Thursday, January 19, 2006 8:35 AM
> To: sqr-users@sqrug.org 
> Subject: Re: RE: [sqr-users] array printing challenge
> 
> 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 
> performas 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 
> 
> 
> 
> _______________________________________________
> 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
Prev by Date: [sqr-users] Re: array printing challenge
Next by Date: RE: RE: RE: [sqr-users] array printing challenge
Previous by thread: Re: RE: RE: [sqr-users] array printing challenge
Next by thread: RE: RE: RE: [sqr-users] array printing challenge
Indexes: [ Thread] [ Author] [ Date]
SQR-USERS List and Archive Info
SQRUG Home Page