SSRS 2008 R2 Expression Help


  • I have a report that pulls in a dataset from a SharePoint list using a SOAP query.  In the data is a identifier that tells me if the data is Survey Type A or Survey Type B.  I'm creating a Matrix that lists the survey questions down the left side and the location across the top.  What I'm trying to do is give a survey score for each location so two columns for each location (they answer the same questions).  My question is how do I get the score for just that survey type for that location?  Whenever I try to show just a Survey A score in the field using an IIF expression it evaluates the first row in my dataset (from SharePoint) against the criteria and stops.  So if the first row is a Survey B response it looks at it and returns nothing, rather than looking at the next row....

    Any help would be greatly appreciated

    martedì 24 aprile 2012 19:36