| Item_Code | Category_ID | Category_Name | Closing_Stock_Qty | Stock_Age |
| 1246060 | 12 | Children shoes | 20 | 2 |
| 1246061 | 12 | Children shoes | 25 | 5 |
| 1246062 | 12 | Children shoes | 60 | 2 |
| 4246060 | 14 | School books | 50 | 6 |
| 4246061 | 14 | School books | 20 | 2 |
| 4246062 | 14 | School books | 50 | 2 |
| 5246060 | 15 | Mobile phones | 25 | 2 |
| 5246062 | 15 | Mobile phones | 60 | 5 |
| 5246061 | 15 | Mobile phones | 30 | 2 |
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:
| Category_Name | Closing_Stock_Qty | Stock_Age |
| Children shoes | 80 | 2 |
| School books | 70 | 2 |
| Mobile phones | 55 | 2 |
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.
Farhan AhmedPosted Aug 11, 2020, 9:51 AM