Re: Real question...

["HALE, Nicole" <NHALE@BAEA.COM.AU>]

Timm,

I don't have the SQR, but if you post it I'll take a look and see what I can
come up with.

Cheers,
Nicole Hale

Analyst / Programmer
British Aerospace Australia

> -----Original Message-----
> From: Buchanan, Timothy [SMTP:buchanan@BIPERF.COM]
> Sent: Wednesday, May 05, 1999 5:09 AM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Re: Real question...
>
> 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