It's dawned on me what you mean by using where clause to regulate results..and somehow doing this in ssrs made me forget basics of query. Thanks for hand up, will try ss soon as at desk. I will add where division_name, etc. Equals the value of the ssrs psrameters passed to it. But, probably will need separate query to control formatting of last two rows. Will try expressions as suggested.