I’m trying to create a SSRS report in BIDS using SharePoint list as data source. I’m trying to create a Matrix report and I need help to do that. The list has columns department type and scheduled dates for each user like “User1, dept 1, 5/8/2011", "user1, dept 2, 5/6/2010,” etc. I have to create a report that shows like this 2011 2010 User Dept1 Dept2 Dept1 Dept2 1 5/8 5/6 The report I have already created shows 2 rows for User 1 with date for respective years. But I want a single row for each user which shows dates for both years like the above example. Any help is appreciated. Thanks

I changed the expression to IIF(Fields!DEPT_VALUE<>"Dept and Year(Fields!Scheduled_date.Value)=2011, Fields!Scheduled_date,"") and this worked. Thanks

Hi Fadnan, Please marked the thread as Answered, if you question is resloved otherwise let us know if you are facing still more issue. Thanks KumarKG, MCTS

Hi, Try this, = IIf ( ( Fields!DEPT_TYPE.Value ="Dept1" OR Fields!DEPT_TYPE.Value ="Dept2" OR Fields! DEPT_TYPE.Value ="Dept3" ) AND ( Year(Fields!SCHEDULED_DATE.Value) = 2011 OR Year(Fields!SCHEDULED_DATE.Value) = 2010 ), Fields!SCHEDULED_DATE.Value,"" ) Please let us know your feedback. Thanks KumarKG, MCTS

Thanks for the reply Kumar, It displays results for the year 2010 but if the user has all 3 department types then the query does not work. For example: User Dept_type Scheduled_date user1 dept1,dept2,dept3. 8/2/2011. for the above scenario the result is null for the year 2011. i hope I made it clear. I have 10 Dept type in total, I'm not sure how to write the expression for combination's. Thanks again for the help.