Strange Results:

[Terry Pickering]

A user pointed this error out in a QUIZ report (710.F4 on Alpha). The
report had a temporary field defined that was a total of several other
fields. Only one of the fields being totaled had anything in it, so it was
easy to spot when the temporary total field did not match.

Using the following quiz report I was able to determine the cause. I was
surprised though that QUIZ did not give any errors at run time. I'm not
even sure how it should have - just think that it should have printed
something like "#########" you see sometimes.

In any case, heres is how the element is defined in the dictionary:

Element:            AMT-YTD-BUDGET
    Usage:              MONEY
    Type:               Numeric
    Size:               11
    Decimal Positions:  2
    Item Defaults:      INTEGER-S Size 8

    Trailing Sign:      "-"
    Input Scale:        10 ^ 2
    Output Scale:       10 ^ 0
    Significance:       5

    Picture:            "^^^,^^^,^^^.^^ "

This is my quiz report and output:

ACCESS GLS-ACCOUNT-MSTR
 
CHOOSE VIAINDEX YEAR-ACCOUNT-KEY FISCAL-YEAR "2000", ACCOUNT-NUMBER
"10021001@"
 
DEFINE T-BUDGET1 INT*8      = AMT-YTD-BUDGET
DEFINE T-BUDGET2 NUMERIC*11 = AMT-YTD-BUDGET
DEFINE T-BUDGET3 INT*10     = AMT-YTD-BUDGET
 
REPORT &
   TAB 1  AMT-YTD-BUDGET PIC " ^^^,^^^,^^^" LEADING SIGN "-" BWZ OUT SCALE
-2 &
   TAB 15 T-BUDGET1      PIC " ^^^,^^^,^^^" LEADING SIGN "-" BWZ OUT SCALE
-2 &
   TAB 30 T-BUDGET2      PIC " ^^^,^^^,^^^" LEADING SIGN "-" BWZ OUT SCALE
-2 &
   TAB 45 T-BUDGET3      PIC " ^^^,^^^,^^^" LEADING SIGN "-" BWZ OUT SCALE
-2 &
SKIP
 

   Amt Ytd      T-BUDGET1      T-BUDGET2      T-BUDGET3
   Budget

 -30,980,000    11,969,673    -30,980,000    -30,980,000


Notice how T-BUDGET-1 is reported incorrectly. It looks like a perfectly
good number though and would be very hard to catch. 

Does anyone else think this is a "bug" and should be reported to Cognos?



Terry Pickering                         CompuGroup, Inc.
pickering@myself.com                    Portland, Oregon USA
www.teleport.com/~compugrp              Cessna 172 & Lancair ES
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.