In an SSRS 2012 report, I am trying to use the following statement and the syntax works but I do not need the distinct rows I want:
iif (first(Fields!schoolNumber.Value) = Fields!schoolNumber.Value,false,true)
Basically what I am trying to do is to use the school number of the first record when the particular report is running, I want to keep the value result set of (school number) returned by the query and save the result somewhere like in a hidden parameter value.
I then want to use the row visibility property, and display the result of the information from each of the rows returned if the results = school numbers are the same.
Basically the information to be displayed are:
- school number,
2, school year,
- student number, and
I cannot create another paramter value since there are 72 existing rdls that already pass school year, student number, and grade among the rdls and I do not want to pass another parameter value around among the existing 72 rdls.
I think using addtional dataset by work, but I do not know how to setup the lookup furnction to accomplish my goal.
Here is the sql I am using right now:
SELECT distinct studentNumber AS StudentNumber , admingrade AS AdminGrade , [schoolNumber] [grade] FROM [dbo].[StudentAssessment] WHERE studentNumber in (@StudentNumber) and admingrade IN (@Grade) AND schoolYear = @SchoolYear
Basically overall I want to display all information for one school number.
Thus would you tell me what I can do to solve the problem?