Hi all, I have SSRS Report with report parameter set to month. but when I add a field and filter by month.. every month I add.. it's adding the total too which should not happen.. like for march.. i have total of 30 and when i add april.. It should show total of 30 for march and 40 for april.. but i'm seeing 70 even on march field too.. can any 1 plz help.. Thanks .. vishal.

Hi all, I have SSRS Report with report parameter set to month. but when I add a field and filter by month.. every month I add.. it's adding the total too which should not happen.. like for march.. i have total of 30 and when i add april.. It should show total of 30 for march and 40 for april.. but i'm seeing 70 even on march field too.. can any 1 plz help.. Thanks .. vishal. Vishal , You can perhaps group on Month and give this expression including Monthgroupscope name in group footer =Sum(Fields!FieldName.Value,"MonthGroupName") Thanks Rajkumar Yelugu

basically , this field is causing the issue... I need the field without sum... but if I take out the sum.. it just bombs.. so.. is ther any aggregate function which comems under the same group that i can use .. or else.. sum or count.. just aggregarates the values.. I tried converting the value to string or varchar... but it dosent work either.. i'm using 2005 =sum(Fields!monthcount.Value, "TotalByMonth")

basically , this field is causing the issue... I need the field without sum... but if I take out the sum.. it just bombs.. so.. is ther any aggregate function which comems under the same group that i can use .. or else.. sum or count.. just aggregarates the values.. I tried converting the value to string or varchar... but it dosent work either.. i'm using 2005 =sum(Fields!monthcount.Value, "TotalByMonth") Can you draft something here what your expecting as output [ a handy image would help better ] Thanks .Rajkumar Yelugu

Report with parameter 2011-04-01 month Count By Month 4/1/2011 428 Report with parameters 04/01/2011 and 03/01/2011 month count by Moth 4/1/2011 850 ----------- I would like to keep it 428 3/1/2011 850 ---------- 422 I could not group it by the field as it will throw up an error.. is there any option to avoid aggregating the field...

Hi vishal, As Rajkumar posted, generally we can first add a group by month, and then using the Sum function in the month group will only aggregates values in the current month. However, I also noticed you could not add a group correctly. So, could you please the dataset structure with some sample data, and also post the expected result? Then, we will try to help you to achieve the requirement. For more information about Adding Grouping, please refer to the tutorial at http://msdn.microsoft.com/en-us/library/ms170623(v=SQL.90).aspx Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support 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.