ssrs , wcf service problem

When you are consuming wcf service in SSRS reports, make sure the following points.
1) WCF Service must be having 'basicHttpBinding' configuration
2) number of parameters, their names, order must be followed as it is.
3) Do not press the 'Refresh' button
4) Write the Query command correctly
5) Enable the following web.config setting in service. This will allow you to view the actual exceptions raised.


even a small mistake will make your life miserable. So, Please take extra care.

Enjoy!! :)

SSRS sub totals using WCF services

SQL Server 2005 reporting services can communicate with services developed using WCF like connecting to SQL Server databases.
Sub totals can be added to the columns by adding the expression to the textbox placed at the table footer.
=Sum(Fields!Salary.Value,"DataSet1")
This works fine in case of report trying to retrieve values from the sql server database using sql queries or stored procedures. But the same expression will give error in case of wcf service.
Make the following change to display the sub totals.
=Sum(CInt(Fields!Salary.Value),"DataSet1")