[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Array Sub divide Question
- Subject: [sqr-users] Array Sub divide Question
- From: "McCown, Larry" <larry.mccown@ngc.com>
- Date: Thu, 30 Jun 2005 08:58:47 -0700
- Delivery-date: Thu, 30 Jun 2005 10:59:59 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: AcV9jJlgjHIyg1WiTxOM6psTQYA6rw==
- Thread-topic: Array Sub divide Question
Greetings,
I have been using SQR for years but never attempted to use an array.
The current report basically requires that I use one.
I am trying to follow the samples in the SQR Server User's Guide Version
4.3 (Program ex8a,b,c. pages 55-67 ) and I get individual output ok.
But what I need to get is subtotals of monthly hours like:
AC (Problem code)
CA (craft) 1 2 2 1 3 1 0 0 0 0 0
0
CU 0 0 0 1 2 2 0 0 0 0 0
0
UW 5 5 6 2 8 5 0 0 0 0 0
0
AC (total) 6 7 8 4 13 8 0 0 0 0 0
0
AD (Problem Code)
CA 0 0 1 1 1 2 0 0 0 0 0
0
CU 1 1 1 2 2 5 0 0 0 0 0
0
UW 5 5 5 6 6 2 0 0 0 0 0
0
AD (Total) 6 6 7 9 9 9 0 0 0 0 0
0
etc.
Can anyone help direct me to a good place to find information on
building array's? This guide is very basic Thank you.
Larry *
Larry McCown
Northrop Grumman Western Region Facilities
One Hornet Way WG00/W5
El Segundo, CA. 90245
Phone (310)628-3939
Fax. (310)332-3149
Larry.McCown@NGC.com <mailto:Larry.McCown@NGC.com>
Words Kill, words give life; they're either poison or fruit - you
choose.
It's amazing what can be accomplished when you don't care who gets the
credit.
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users