Thank u very much it is working

It is a Tabular Report No groups for Rows and columns for this Report just i want to display the column heading with that expression instead of typing Depositamount/Loanamount/closingbalance...

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...

Yes the datasource have access to run the proc i have designed so many reports using the same datasource and same database.

Another thing is when we select new report option...

Thank You very Mucj it is working fine

This is the report i required with Fieldnames as No,Name and Balance

with group as agent

Agent 1

No Name balance

1 ...

Thank u but my problemi is i want to display the report like this

Agent 1

NoName balance

1Ramesh1000

2Suresh2000

3Rajesh1000

Total4000

Agent 2

NoName ...

Ok thank u i have added the lines through borders.

Thank You very much it is working fine

I want to take only Triggers in Sql server 2008 R2 database to execute in another database.The Database having more than 25 triggers instead of excuting individually i want to...