SSRS 2008 R2 Expression Help
-
martedì 24 aprile 2012 19:36
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
Tutte le risposte
-
martedì 1 maggio 2012 06:17Moderatore Hi Sam,
In your case, could you please post some sample data and the current report result to us? Then, we will help you to solve this issue.
Generally, we can use IIF() function to get the expected records for a report. For a matrix, it can grows horizontally and vertically on the page. I think that you can design the matrix like this:
For more information, please see:
Expression example: http://technet.microsoft.com/en-us/library/ms157328.aspx
Regards,
Bin LongBin Long
TechNet Community Support
- Contrassegnato come risposta Elvis LongMicrosoft Contingent Staff, Moderator mercoledì 2 maggio 2012 10:06
.png)
