I have the table shown above. I want to make an RDLC report which can filter the above table and
Produce the report based on the stock_ age. That is I want to have a summary report based on the stock_age and grouped by category_name . For example I want to filter according to stock_age =2
and get the following report:
I have tried to use
=Sum(IIF(Fields!Stock_Age.Value=1,Fields!Closing_Stock_Qty.Value,0))
Kindly assist me to sort out this issue since Iam new to C# rdcl reports.