Report Builder - List POs with no lines

The way to filter on left outer joins is to look for a condition that

absence meets. Create a formula for that condition and filter on it.
like iif(POLine >= 1, no, yes). Every PO without a line it returns a
yes. Filter for the yes and you got it.
Oh and I just turned up 23 blank PO's here.


> I am looking for a report that lists all POs without any line items.
>
> Occasionally we get these from our buyers starting, but not
> finishing a PO.
>
> Thanks,
>
> Doug Oswald
> MIS
> Fleetwood Fixtures
>
>

Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com
I am looking for a report that lists all POs without any line items.

Occasionally we get these from our buyers starting, but not
finishing a PO.

Thanks,

Doug Oswald
MIS
Fleetwood Fixtures
I have a report like this that I run once a month - but it's in Access so
not easily shareable.

However, you could write it fairly easily in Report Builder.

1.) Left outer join POHeader table to PODetail table.
2.) Sort and group on PONum
3.) Add the fields you want to the PONum Group Footer (i.e. PONum, Buyer,
order date)
4.) Create an Aggregate Count field on PO line
5.) suppress all record lines
6.) filter on 'Company' and OpenPO
7.) Conditional print the group PONum footer to print when the aggregate
count field = 0

Should work - let me know if you have ?'s




[Non-text portions of this message have been removed]
Rather than aggregating couldn't you just filter on PO Line = ? (unknown) ?
-Todd C.


-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Wednesday, June 11, 2003 3:27 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder - List POs with no lines


I have a report like this that I run once a month - but it's in Access so
not easily shareable.

However, you could write it fairly easily in Report Builder.

1.) Left outer join POHeader table to PODetail table.
2.) Sort and group on PONum
3.) Add the fields you want to the PONum Group Footer (i.e. PONum, Buyer,
order date)
4.) Create an Aggregate Count field on PO line
5.) suppress all record lines
6.) filter on 'Company' and OpenPO
7.) Conditional print the group PONum footer to print when the aggregate
count field = 0

Should work - let me know if you have ?'s





[Non-text portions of this message have been removed]
That's easier... for some reason I thought you couldn't filter on null
fields in a left-outer join, but I'm probably wrong...



[Non-text portions of this message have been removed]