Control break summaries in QTP

[Maloney, Charlie]

Oops!  Yes, of course, you're right...

You can't subtotal "AT START OF".  
You can't do ANY summary operation AT START OF.
Or even an "ITEM =", for that matter.

Don't know what I was thinking.

But the timing problem remains.  
You need to set your variable BEFORE you write out at detail time.

Oh, well...

Charlie Maloney
Technical Account Manager
Charlie.Maloney@cognos.com
PH:  781 313 2305
FX:  781 229 6426


-----Original Message-----
From: Rich `Lego-Man' Jesse - 7633 [mailto:RJESSE@QTIWORLD.COM]
Sent: Tuesday, September 14, 1999 1:40 PM
To: Charlie.Maloney@Cognos.com
Cc: powerh-l@lists.swau.edu
Subject: Re: Control break summaries in QTP


Charlie Maloney replied to my post:

CH> Without analyzing your program in great detail...
CH> 
CH> Here's the timing for output phase PROCESSING in QTP:
CH> (It's slightly different for output phase INITIALIZATION, 
CH> never mind that for now)
CH> 
CH> 
CH> 1.  "AT INITIAL"
CH> 
CH> 2.  "AT START OF" sortitems, major to minor
CH> 
CH> 3.  detail
CH> 
CH> 4.  "AT" sortitems, minor to major
CH> 
CH> 5.  "AT FINAL"
CH> 
CH> Your OUTPUT ADD operation takes place at step 3, detail time.
CH> Your SUBTOTAL operation takes place at step 4, the END OF the THIRD SORT
CH> BREAK,
CH> which is AFTER the 'detail time'.
CH> 
CH> The way the program is written, BIN_COUNT can never have the value of 1
CH> in the first record.  
CH> 
CH> While I haven't examined the program in detail, 
CH> perhaps you could do your subtotal "AT START OF" your third sort break.

Hmmmm... the "AT START OF" option is a new one to me.  Do you know if it's
available in 7.33.D3?  QTP complains about it, and I can't find it in the
manual, except as an option for the COMMIT statement.

Rich

Rich Jesse                              Programmer/Analyst
(/DBA/SysAdmin/etc.)
rjesse@qtiworld.com                     Quad/Tech International, Sussex, WI
USA
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.