Aye separating the query seems to be the way forward, although it just feels "dirty". I mean we're talking 11 reporting queries, each will have 3 ISNULL parameters, thats 33 queries just to get some real basic functionality.

I wonder why is this happening interms of the SQL engine itself, it seems very counter-intuitive for essentially a simple problem:

"I want to return either a filtered result set (while utilizing the index), or all the result set (doing a table SCAN)"... weird!

I would rather not go down the dynamic SQL route, just interms of maintenance/debugging/administering/security etc..

Thanks for the prompt reply!!

/>L