Shared variable to return

[Jackmetickler]

XTAL 11 SQL 2005

Hello there,
I will attempt to briefly explain my problem -

I have 2 reports.

1 is a list of parts required to make a product. (BOM)
2 is a list of the parts we purchased to make a batch of that product.
They differ in as much as we may have a number of parts in stock, so the second will only list the parts we actually purchased for a particular batch.

I am attempting to do a material variance type report.
I wish to list the parts we have purchased and then a sub-report to show the BOM minus the Parts we have purchased.
Is there a way I can return from a sub report any part that does not match a part in the main report.


If not is there any way I could attempt this.

I hope that makes some sense.

Jack

 

[lbass]

If these are in two separate tables, e.g., BOM and Purch, then you can use a left join FROM BOM TO Purch on PartNo, and add a record selection formula to your report:

isnull({Purch.PartNo})

This would return all BOM Parts that had no corresponding purchases.

-LB

 

[Jackmetickler]

Unfortuantely that wont work in this scenario because all parts in the BOM have been purchased at some time - I just need to know about the parts that have been purchased against a particular Sales Order.

I think I need to give you more detailed information to give you any chance of helping me.

I will attempt to get something more helpful together and come back

Jack