Hi! I have and existing .rdlc file where I display the grades of each students as well as the general average. I get general average like
=FormatNumber(Switch(Fields!YearLevel.Value="LC7" or
Fields!YearLevel.Value="LC8",(IIF(Fields!SectionName.Value<>"1st Sec A" and
Fields!SectionName.Value<>"2nd Sec A",
((Fields!Reading.Value * 1.2) +
(Fields!English.Value * 1.5) +
(Fields!Math.Value * 1.5) +
(Fields!Science.Value * 1.8) +
(Fields!Language.Value * 1.2) +
(FormatNumber((Fields!TLE.Value * .70) + (Fields!Computer.Value * .30),0) * 1.2) +
(Fields!MAPEH.Value * 1.2) + (Fields!CLE.Value * 0.9))/10.5,
((Fields!Reading.Value * 1.2) +
(Fields!English.Value * 1.5) +
(Fields!Math.Value * 1.5) +
(Fields!Science.Value * 1.8) +
(Fields!Language.Value * 1.2) +
(FormatNumber((Fields!TLE.Value * .70) + (Fields!Computer.Value * .30),0) * 1.2) +
(Fields!MAPEH.Value * 1.2) +
(Fields!CLE.Value * 0.9) +
(Fields!Earth_Science.Value * 1) +
(Fields!Geometry.Value * 1)) /11.5 )),
Fields!YearLevel.Value="LC9",
(IIF(Fields!SectionName.Value<>"3rd Sec A" ,
((Fields!Reading.Value * 1.2) +
(Fields!English.Value * 1.5) +
(Fields!Math.Value * 1.5) +
(Fields!Science.Value * 1.8) +
(Fields!Language.Value * 1.2) +
(FormatNumber((Fields!TLE.Value * .30) +
(Fields!Computer.Value * .70),0) * 1.2) +
(Fields!MAPEH.Value * 1.2) +
(Fields!CLE.Value * 0.9))/10.5,
((Fields!Reading.Value * 1.2) +
(Fields!English.Value * 1.5) +
(Fields!Math.Value * 1.5) +
(Fields!Science.Value * 1.8) +
(Fields!Language.Value * 1.2) +
(FormatNumber((Fields!TLE.Value * .30) + (Fields!Computer.Value * .70),0) * 1.2) +
(Fields!MAPEH.Value * 1.2) +
(Fields!CLE.Value * 0.9) +
(Fields!Research1.Value * 1) +
(Fields!Adv_Biology.Value * 1)) /12.5)),
Fields!YearLevel.Value="LC10",
(IIf(Fields!SectionName.Value<>"4th Sec A" and Fields!SectionName.Value<>"4th Sec B",
((Fields!Reading.Value * 1.2) +
(Fields!English.Value * 1.5) +
(Fields!Math.Value * 1.5) +
(Fields!Science.Value * 1.8) +
(Fields!Language.Value * 1.2) +
(FormatNumber((Fields!TLE.Value * .30) +
(Fields!Computer.Value * .70),0) * 1.2) +
(Round((Fields!Music.Value * .30) + (Fields!APEH.Value * .70)) * 1.2) +
(Fields!CLE.Value * 0.9) +
(Fields!CAT.Value * 0.3))/10.8,
((Fields!Reading.Value * 1.2) +
(Fields!English.Value * 1.5) +
(Fields!Math.Value * 1.5) +
(Fields!Science.Value * 1.8) +
(Fields!Language.Value * 1.2) +
(FormatNumber((Fields!TLE.Value * .30) + (Fields!Computer.Value * .70),0) * 1.2) +
(Round((Fields!Music.Value * .30) +
(Fields!APEH.Value * .70)) * 1.2) +
(Fields!CLE.Value * 0.9) +
(Fields!CAT.Value * 0.3) +
(Fields!Adv_Chemistry.Value * 1) +
(Fields!Research2.Value * 1))/12.8))),3)
I want to display:
"1st Honor" if gen. ave is >=90 but all the subject grades must be >=90 also
"2nd Honor" if gen. ave is >=88 but all the subject grades must be >=88 also
"Third Honor" if gen. ave is >=85 but all the subject grades must be >=85 also
How do I do it?
thanks in advance.