Thanks Jack and Toolman .I was able to work it out as mentioned below :

=CInt(sum( IIF( Fields!category.Value = "FA", Fields!Totals.Value, 0),"table5_Group1"))

The expression was returning a char value on the whole.When...

Thanks Jack , the jpg file has the same expression as defined by me.Is the group to be the same as specified in the expression.

Thanks , I am using sql 2000 reporting services.also when i declare the value as specified by you it still gives the same error

it is working with count but not with sum.

yes it is

even =sum( Fields!Totals.Value,"table5_Group1") in the filter with the operator say > 100 does not work and ends up with the same mentioned above error.

Could you please look into it.It is...

Thanks Jack,

The query works fine if i use it in a textbox of a table , but if i use it in a filter of the group1 of teh table5...

thanks , steve but there is nothing like that happening in the report.Moreover it is not running the first time in the vb.net environment but if i run it after...

TRY : select * from sysprocesses where status='running'

check for the cpu column utilization and check which process is being run by the spid.

Probably you have defined the default option as the backup folder.In the maint. plan , in the 'define Backup Database option' , you can define the path for the network...

yes even if the database corrupted the point in time restore is possible.

Thats right , this is generally due to a hardware error.I would suggest that you run dbcc checkdb to see if the database msdb has errors and correcting it along...