quiz, last nonblank

[Chris Sharman]

>Get Cognos to add temporary items and item statements to Quiz, just like in
>Qtp :-)

Perhaps more practically, for a solution sometime soon, use a QTP pass.

In Quiz, you can play about with max, min, conditional defines: that will
probably do the job for you if you want the largest or smallest non-blank
value. If you really want the last, not necessarily largest or smallest, then
it will have to be QTP.

> I am reporting a set of records which contains a field that may be blank
> because the related record was optional.  How can I define a field such
> that
> it contains the current value of the problem field if is there (not blank
> or
> empty) otherwise it will contain the last real value for that field
> encountered so far in the report.

Chris
_______________________________________________________________________
Chris.Sharman@CCAgroup.co.uk		http://www.ccastat.demon.co.uk/
CCA Stationery Ltd, Eastway, Fulwood, Preston, Lancashire, PR2 9WS.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.