Thanks All...for your replies..

I was unable to resolve this from SSRS..took help from SQL.Since there is no other go and time was running away , i had to convince everyone...

Dbowlin....

I tried whatever u suggested. I have created hidden columns for both credit and debit.

And got the values in the columns successfuly.

But when i try to sum these...

Thanks dbowlin... will try and get back to you..:-)

Dbowlin...

Your understanding is correct...

Actually my problem is that in the report i am not referring the dataset field directly for amount and count. I get the raw data and...

Thanks Tom...

I already tried the expression u mentioned but i got the error as :

The Value expression for the textbox txtCRTotal refers to more than one report item. An...

Hey Lutz......

U r right....i have the same doubts though but i instructed to bring the max benifits of using ssrs and it is one among them.

i have to do all...

Thanks Lutz for your reply...

I cannot use it in the sql part. The requiremment is such that i should get the raw data from the tables and perform all others...

Thanks dbowlin for the reply.

But this is not what Iam trying to do. Iam trying to call a custom code from expression which Iam not able to perform successfully.

Please go...

SSIS 2005 script task dosnt support C# scripts...

SSIS 2008 can use either C# or VB.net scripts, which is one of the majors enhancements over SSIS 2005.

Anyone has any idea on this ????? Please help me...

Got a fix myself....

this problem persists even after removing the filters to the sheet. Filers will be disabled but the sheet Sheet1$_ will still exists. To resolve this , I...

I tried giving it the way u said without properties. but still it is not taking the values.

the statement iam using is

dtexec /SQL "\BPCSBudget" /Server "IN-HRPORTAL\SQL2005"

/SET \Package.Variables[User::FolderPath].Properties[Value];"D:\Inbox\Sivaraj\BPCSUpdatedPackages\BPCSBudget.xls"

The package is working fine but iam not able to pass the variable values iam giving in the above...

Great...worked fine for me.thanks all

Hey All.....thank you so much for your replies.

But I will be getting 1000's of rows everyday. How will I give the select stmt in that case ?

With Table1

(

---this select...