Use of switch, Sort and Group in SSRS Report

Use of Percentage in Chart Level value

-------------------------------------------------------

"#PERCENT{P0}"

Use of Switch case in SSRS report

--------------------------------------------------

=switch(

        Fields!application.Value="Pump","Pump",

Fields!application.Value="Fan","Fan",

Fields!application.Value="Compressor","Compressor",

Fields!application.Value="Conveyer","Conveyer",

Fields!application.Value="Crusher","Crusher",true,"Others")

Group/Sort SSRS record in Chart 

------------------------------------------------

Group

=UCASE(Trim(FORMAT(CDate(Fields!submitteddate.Value), "MMM-yyyy")))

Sort

=CInt(Trim(FORMAT(CDate(Fields!submitteddate.Value), "yyyyMM")))