Hi Old hand,

i think the OP means he need some average data for 1 particular column even while only a subset is returned in the actual report

If this is the case then i would look into Creating a SP (not needed but easy to maintain)

and some code like the one below (just example, not working code)

;with cteData as (

select col1,col2, datecol1, sum(numcol) as totalFordataset from table x

)

select * from cteData where datecol1 between @DateFrom and @DateTill

You cab easily put this into SSRS Querywindow, it should work without a stored procedure to.

Hope this helps you on your way

Wkr,

Van Heghe Eddy