Function for grading in RDLC report

makumbi

SOLVED CLOSED ACTIVE ANSWERED
User: makumbi
Posted: on Mar 29, 2024 10:18 PM
Forum: Crystal Reports with ASP.Net
Replies: 2
Views: 759

I am having this function in my rdlc report but i run the report the moment it reaches the ranges of 65 it does not show the corresponding grade

84	A
76	B
65
68	B

Public Function grading(tt) As String
    if IsNothing(tt) then
        grading = Nothing
        Exit Function
    end if

    tt = int(tt)
   
    if (tt >= 0 and tt <= 44) then
                grading = "E"
    else 
            if (tt > 45 and tt <= 54) then
                grading = "D"
    else 
            if (tt > 55 and tt <= 64) then
                grading = "C"
    else 
          if (tt > 65 and tt <= 79) then
                grading = "B"
    else 
            if (tt > 80 and tt <= 100) then
                grading = "A" 
    end if
end if
end if
end if
end if
End Function

please help

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
User: dharmendr
Replied: on Mar 29, 2024 10:36 PM
Report

I am checking it. I will get back to you soon.

dharmend...

0 2

Reply
User: dharmendr
Replied: on Mar 30, 2024 01:20 PM
Report

Hi makumbi,

You are defining the function to returning String value, but not returning any value from it.

You need to modify the function to return a value from it.

Refer below function.

Public Function grading(tt As Integer) As String
    Dim grade As String = Nothing
    If IsNothing(tt) Then
        grade = Nothing
        Return grade
        Exit Function
    End If
    tt = Int(tt)
    If (tt >= 0 And tt <= 44) Then
        grade = "E"
    ElseIf (tt > 45 And tt <= 54) Then
        grade = "D"
    ElseIf (tt > 55 And tt <= 64) Then
        grade = "C"
    ElseIf (tt > 65 And tt <= 79) Then
        grade = "B"
    ElseIf (tt > 80 And tt <= 100) Then
        grade = "A"
    End If

    Return grade
End Function

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Function for grading in RDLC report

Company

Explore

Follow us

Contact Us