Re: Real question...

["Korbel, Gordon E." <GEKORBEL@NORSTAN.COM>]

The only way I was able to resolve the as-of dating issue (cleanly, at
least), was to replace all of the non-header print statements with writes to
a 'print array' and determine if they need to be printed after resolving
PS_ITEM and PS_ITEM_ACTIVITY based on the as-of date.

The only other solution I came up with was moving the cursor backwards in
the report file, overwriting 'blank' lines with spaces, and then printing
the next line.  I chose not to implement this solution so I am unsure if it
would even work.

eg, print ' ' (-3,1,100) FILL or similar.

A classic case of not knowing what you need to know when you need to know
it.

-Gordon

-----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