[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: "Knapp, Richard" <KnappR@umsystem.edu>
Date: Fri, 20 Jan 2006 10:59:22 -0600
Delivery-date: Fri, 20 Jan 2006 12:02:11 -0500
List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Thread-index: AcYdE9gBIMxHeTc1TuqB7aXvBC0apQAy3iQAAAAuSyAAAEe8MA==
Thread-topic: RE: RE: [sqr-users] array printing challenge

Good question.

The original inquiry was (and still is) vague.  This permits people to
project their favorite solutions and tidbits onto it.  The tough work of
clarifying the requirements is thus avoided and the field remains wide
open for anything anyone wants to say.  Under these conditions, damsels
in distress appear to be rescued and our magnanimous natures are on
display for all to see.

Also agree with Dave.


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
Bob Stone
Sent: Friday, January 20, 2006 10:40 AM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: RE: RE: [sqr-users] array printing challenge

Why does a question like this get 50+ responses, and tough valid SQR
conundrums are lucky to get 1?


-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org] On Behalf Of
Bob Helm
Sent: Friday, January 20, 2006 10:34 AM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: RE: 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

_______________________________________________
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: RE: RE: RE: [sqr-users] array printing challenge
Next by Date: [sqr-users] sql delete from table where 1 = 1
Previous by thread: RE: RE: RE: [sqr-users] array printing challenge
Next by thread: [sqr-users] Printing text vertically
Indexes: [ Thread] [ Author] [ Date]
SQR-USERS List and Archive Info
SQRUG Home Page