Hi all,
I m developing a SSRS report which has to show data based on month and based on report parameter selected,
The fields in my table are
:ItemId
Category
MonthName
MonthNumberTwo -----> lenth of container containing the monthname objects fetched from given data range
QTY
VALUE
I have row grouping on group on properties: if(item category is selected, group on category, else group on itemid ).
I have column grouping on MonthName thats shows qty and value for the given date range.
I need to show avg column , in the report, as shown in the image below:
I am calculating Avg of qty and value as:
Sum(Fields!QtyTwo.Value) / Fields!MonthNumberTwo.Value
Qty:
Sum(Fields!QtyTwo.Value)/Fields!MonthNumberTwo.Value
The problem I am facing here is, when i access the field out of MonthName group:
Fields!MonthNumberTwo.Value =0
Sum( Fields!MonthNumberTwo.Value )= sum of no of months occurence
I wanted to access the Fields!MonthNumberTwo.Value as it is.
I am not able to figure out why the MonthNumberTwo is getting override to 0 in report while RDP class in debugger is working correctly.
Your suggestion would be really helpful.
Thanks.


Note: I have done full model synchronization, build, services restart and VM restart.