Unable to search in calculated result

[gillian]

Hi I have a problem whereby I have a table called Stock that calculates a total stock based upon records in another table - account ledger. It is slightly quirky in that the portal has a global date field that is part of the relationship so that it restricts records to all those less than the date specified as well as a stock code match. I do this so that I can run a report on the account ledger table, but want to eliminate all stock with a '0' positions.

In my script I go to the stock table, then constrain the found set to omit those with a total = 0, then view all matched account ledger records across all the stock records ; except it doesn't work when it is hosted.

Is this bad practice? Any other ideas of how I can run a summary report on the account ledger without showing those that total 0 in the summary would be appreciated, or why it is failing when hosted would be much appreciated.

Thanks