I have a BAQ that gives me kind of a stock status report by warehouse bin. It works fine during the month, but crossing the month end, the numbers are changed with new transactions.
Another BAQ gives me quantity-changing transactions. I need to merge these two for using in a dashboard and SSRS report.
A union subquery will do the trick, but I'll have to replicate the whole query up to PartWhse and substituted PartTran for PartBin. And it would be nice to sum the transactions in the query.
Anyone have an easier way than the union method?
Thanks,
Joe
--
Joe D. Trent
Bigham Ag Equipment