Counter increment w/o SET SUBFILE AT....

[John Webster]

What Charlie could have explained is the reason for the 'bad' behaviour...
What you were missing is that by default Quiz resets subtotals at the lowest
level sort-key (in your case ML-NO). Adding NORESET overrides the default
behaviour.
John W
----- Original Message -----
From: "Maloney, Charlie" <Charlie.Maloney@Cognos.com>
To: "'Karman, Al'" <AKarman@usfreightways.com>; <powerh-l@sphere.swau.edu>
Sent: Tuesday, November 7 2000 08:13
Subject: RE: Counter increment w/o SET SUBFILE AT....


> Q U I Z   (PowerHouse  8.21.D2)
> Copyright 2000 COGNOS INCORPORATED
> Licensed PH8-TEMPORARY for customer: 0712570003 COGNOS WINNT DEMO
>
> > use x
> > acc branches
> > define d_init_value = 10100
> > define d_counter = 1
> > sort on country_code
> > rep country_code &
> >     branch_code &
> >     d_counter sub at country_code init value d_init_value noreset
> > go
> 06-NOV-2000                    The Great Outdoors
PAGE
> 1
>
>   Country  Branch  D_COUNTER
>    Code     Code   (SUBTOTAL)
>
>    AUS      MEL       10101
>    AUS      SYD       10101
>    BEL      BRUS      10102
>    CAN      MTL       10103
>    CAN      TOR       10103
>    CAN      VAN       10103
>    FRA      PAR       10104
>    GER      FRNK      10105
>    HKG      HKG       10106
>    ITA      ROM       10107
>    JAP      TOKY      10108
>    MEX      MEX       10109
>    SING     SING      10110
>    SPA      MADR      10111
>    SWE      STOC      10112
>    UK       LON       10113
>    UK       MAN       10113
>    USA      BOS       10114
> ?
> -----Original Message-----
> From: Karman, Al [mailto:AKarman@usfreightways.com]
> Sent: Monday, November 06, 2000 1:42 PM
> To: powerh-l@sphere.swau.edu
> Subject: Counter increment w/o SET SUBFILE AT....
>
>
> Good day to all.......
>
> It certainly seemed easy enough......sort on this 'ML-NO', and each time
the
> ML-NO changes, increment this SHIPMENT#  by one....
> e.g.   ML-NO SHIPMENT#
> 001 10101
> 001 10101
> 002 10102
> 003 10103
>
> What am I missing to get this badboy to increment...It's only writes
'10101'
> currently for all values of ML-NO
>
> As Always, TIA...!!!
>
>
> DEF SHIPMENT# NUM*5 = (10100 + 1)
> ;
> SOR ON ML-NO
> ;
> SET SUBFILE APPEND KEEP NAME SHIPMENT &
>   INDEX IX1 SEGMENT MR-NO,            &
>   INDEX IX2 SEGMENT PO-NO,            &
>   INDEX IX3 SEGMENT PL-NO,            &
>   INDEX IX4 SEGMENT ML-NO
> ;
> REP SUMM                       &
>   MR-NO                        &
>   PO-NO                        &
>   PL-NO                        &
>   ML-NO                        &
>   SHIPMENT# SUB AT ML-NO       &
>   DIMENSIONS
>
>
> Al Karman
> IT Consultant
> US Freightways
> akarman@usfreightways.com
> 773.824.2284
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
=
> Subscribe: "subscribe powerh-l" in message body to
majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> This list is closed, thus to post to the list, you must be a subscriber.
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
=
> Subscribe: "subscribe powerh-l" in message body to
majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> This list is closed, thus to post to the list, you must be a subscriber.
>

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.