I have to show 2 grids ith the agregated data when a user selects date parameters from and To date, and a weekly parameter. if a user selects daily and from(5/5/2009), to dates(5/10/2009) then i need to show that many grids i.e 5 grids with the daily aggregate totals. Please explain how i can achieve in ssrs report. all hlp is great help.

Hi, First, I need to confirm your expectation. Do you mean need the report meet the following requirements? 1. Filter records in the report by date parameters Form and To. 2. Aggregate totals daily/monthly/weekly by another parameter. If so, to filter report data, I would suggest you refer to the article Using Parameters to Control Report Data at: http://msdn.microsoft.com/en-us/library/aa337287.aspx In order to aggregate totals daily/monthly/weekly by parameter, we can first add row group by the expression like =Switch( Parameters!Level.Value=”Daily”, DateValue(Fields!Date.Value), Parameters!Level.Value=”Weekly”, Year(Fields!Date.Value) & DatePart(DateInterval.WeekOfYear,Fields!Date.Value), Parameters!Level.Value=”Monthly”, Year(Fields!Date.Value) & Month(Fields!Date.Value), ) After that, report data will be grouped based on the Level parameter dynamically, and then we can add the aggregation at the group footer. Thanks, Tony Chain Tony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.