Re: Real question...

["Buchanan, Timothy" <buchanan@BIPERF.COM>]

Steven,

Thanks for the reply, but things are a little more complicated than that. I
have used SQR for over a year or 2, so I know what I am trying to do with
this SQR, but I cannot figure an easy way to fix it without re-designing how
Peoplesoft wrote the SQR. Take a look at the sqr and you will see  what I
mean. Thanks!
Timm


On Tuesday, May 04, 1999 2:07 PM, Ross, Steven [SMTP:sross@KCM.ORG] wrote:
> I haven't seen that specific SQR, but the concept (in general) is pretty
> straight forward.
>
> You have to test if there is data.  If there's data, you print; if not,
you
> don't.
>
> Like this:
>
> if #financial_data > 0
>         print #financial_data (y, x)
> end-if
>
> Again, I haven't looked at that specific SQR, so it may not be that easy,
> but most likely, it is.
>
> Hope this helps,
>
> Steven Ross
> Programmer/Analyst
> sross@kcm.org
>
>
> -----Original Message-----
> From: Buchanan, Timothy [mailto:buchanan@BIPERF.COM]
> Sent: Tuesday, May 04, 1999 12:08 PM
> To: Multiple recipients of list SQR-USERS
> Subject: Real question...
>
>
> 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