hi,
In my Dataset I have 3 columns "EducationLevel","Skill" and "PreferenceType".In the report I have a field called marks.I give marks adding above 3 column values.i.e
If "EducationLevel" is (High,15 marks),(Medium,10marks),(Low,5 marks).
If "PreferenceType" is ("First" 15 marks),("Second" 10 marks),("Third"5 marks)
If "Skill" is (High,15 marks),(Medium,10marks),(Low,5 marks).
The Marks field should display aggregate of all 3 marks obtained from above 3 fields.
How can I write the expression for it?
thnx in advance
Dimansu
0
Light Poster
Recommended Answers
Jump to PostIf or Select statement with custom code.
Jump to PostCustom Code block - RDLC
Dim tot as integer=0 If EducationLevel="High" Then tot=tot+15 Else If EducationLevel="Medium" Then tot=tot+10 Else tot=tot+5 End If End if If PreferenceType="First" Then totl=tot+15 marks .....
All 6 Replies
kvprajapati
1,826
Posting Genius
Team Colleague
Dimansu
0
Light Poster
kvprajapati
1,826
Posting Genius
Team Colleague
Dimansu
0
Light Poster
kvprajapati
1,826
Posting Genius
Team Colleague
Dimansu
0
Light Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.