Unfortunately I have no experience with said tables, but... are you running the latest service pack and/or have you browsed Microsoft's hot fix list? Sounds a bit like a bug to me.
--Marko On 10/01/2008, James Flavell <[EMAIL PROTECTED]> wrote: > > Sorry for the many posts > > Okay it seems the 145,000 records are for ALL items and ALL warehouses (or > all inventory dimensions you might have ticked to print) even though I > only > set teh filter as one item and one warehouse! > > I am not sure if it is a bug and it should have only created > InventSumDateTrans for the one item but to me if you give me the option to > filter that implies I can spee up my report by only printing the items I > need... > > I guess 10 mins or so for ALL items is not so bad but I wish MS would have > made it clear...I am sure every user under the sun would be complaing > about > having to wait 10 mintues to get only 1 item! > > Thanks > James [Non-text portions of this message have been removed]