Re: Real question...

[Art DiRamio <ADiRamio@OPENSOLUTIONS.COM>]

I don't have the peoplesoft code, but it seems like they are using a
master-detail type scheme.  If this is the case, you have a couple options.

1 - you could add an exists clause to the master select to check for the
existence of detail rows for each master row.  That would prevent masters
with no detail from getting selected.

2 - you could break out the printing of the master section and have the
master information conditionally print before the first detail record of
each.

I know it's a pain in the $#% to rip apart the code, but sometimes it's for
the best. . .

Art DiRamio
Open Solutions Inc
Glastonbury, CT


                -----Original Message-----
                From:   Buchanan, Timothy [mailto:buchanan@BIPERF.COM]
                Sent:   Tuesday, May 04, 1999 3:39 PM
                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