I could not understand in much detail about your problem. But I think, it is related to Distributed Partitioned vie.

Please go through the below link:

http://msdn.microsoft.com/en-us/library/aa175250(v=sql.80).aspx

It might help you.

Regards,

Mahendra...

I am not sure.. need to try this..

I think you can hide the extra parameters displaying. and assing the values to to the hidden parameters as the one which...

Hi Andy,

Excellent Article. Personally I never thought of GROUPING in this way in SSRS report.

Keep it up.. !! your atricle really helped..