Only works if I choose one hospital...I'm attaching a dummy table and .rdl file.

If you choose "All", then the first hospital will work fine, the second hospital has 3 then 2, the 3rd hospital has the same.

Could anyone help? this is the only report still on the 2005 server and we need to close it so we can move everythying to the 2008 server.

Frustrating... to say the least.

Any help would be great!

larry