CODEWITHSUNDEEP
ssrs-2008
Gurrah Ul Qaumi
Gurrah Ul Qaumi

Reputation: 1

Add Symbol () in report ssrs

I have code : CourseName + ' ' + isnull(GradeLevel,'')) as CourseName The result : Permit Working High 3

How to make result like this : Permit Working High (3)

Upvotes: 0

Views: 40

Answers (1)

Alan Schofield
Alan Schofield

Reputation: 21758

CourseName + ' ' + 
    CASE 
        WHEN GradeLevel IS NULL THEN '' 
        ELSE '(' + GradeLevel + ')' 
    END 
AS CourseName

Upvotes: 1

Related Questions