Re: Real question...

["Ross, Steven" <sross@KCM.ORG>]

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