Re: Real question...

[Ketan Kothari <ketan@MASTECH.COM>]

Hi
 We did a little modification in the where clause of the procedure main process.

added this extra where clause
  AND B.BAL_AMT_BASE <> 0

old code
  AND V.RECNAME = 'CUSTOMER'
ORDER BY [$order-by]

So the code now looks
  AND V.RECNAME = 'CUSTOMER'
  AND B.BAL_AMT_BASE <> 0
ORDER BY [$order-by]

"Buchanan, Timothy" wrote:

> Ok, a real question for the group. IF you have AR, take a look at
> AR30003.sqr. My client would like this report, and others like it, to
> suppress printing the business unit and customer ID info if there is no
> financial data associated with it on the reporty. example:
>
> NOW:
>
> Item       Line As Of      Ent Typ/Rsn Terms Document    Cur Amount
> ---------- ---- ---------- ----------- ----- ----------- --- ---------------
> MODEL           00050           test1
>
> MODEL           01225           test2
>
> MODEL           02256           test3
> 123198        0 12/14/1995 CO_CR  TR   RCPT              USD
> 280.38-
> 280.38-
> ----------------------------------------------------------------------------
> ------------------------------
>
> GOAL:
> Item       Line As Of      Ent Typ/Rsn Terms Document    Cur Amount
> ---------- ---- ---------- ----------- ----- ----------- --- ---------------
> MODEL           02256           test3
> 123198        0 12/14/1995 CO_CR  TR   RCPT              USD
> 280.38-
> 280.38-
> ----------------------------------------------------------------------------
> ------------------------------
>
> Unfortunately, I have been messing with the peoplesoft delivered SQR for a
> while now, and I cannot figure out how to do this without major
> modifications. Has anyone else had to do this, or can anyone help me with
> any ideas??? Thanks.
>
> Timm