Temporary table field value, is getting override to 0 at SSRS report

(0) Share

Report

Posted on by Asmita Sunuwar

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.

image_5F00_2023_5F00_01_5F00_06T10_5F00_28_5F00_34_5F00_981Z.png

image_5F00_2023_5F00_01_5F00_06T10_5F00_38_5F00_25_5F00_591Z.png

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

All responses (2)

Answers (0)