• Actually i want like this

    If {Reportname.CategoryCode} = 'DEPOSIT' And {reportname.WithdrawalType} = 'S' Then

    'Deposit Amount'

    Else If {BReportname.CategoryCode} = 'LOAN' Then

    'Loan Amount'

    ELSE If {Reportname.CategoryCode} <> 'LOAN' AND {Reportname.CategoryCode} <> 'DEPOSIT' Then

    'Closing Balance'

    Else

    'Closing Balance'

    Categorycode and withdrawaltype are fieldnames which is in my table

    categorycodes are (LOANS,DEPOSIT,SHARES,SUSPENCE)

    Withdrawaltype are (Multiple (M),Single(S)

    "Deposit Amount"

    "Loan Amount"

    "Closing Balance" are Column Headings which i want so i added like this

    =Switch(Fields!CategoryCode.Value = "DEPOSIT" And Fields!WithdrawalType.Value = "S" , "Deposit Amount",

    Fields!CategoryCode.Value = "LOAN" ,

    "Loan Amount",

    Fields!CategoryCode.Value <> "LOAN" AND Fields!CategoryCode.Value <> "DEP",

    "Closing Balance","Closing Balance")