Hello,
I am trying to add some fields to my report (Using SQL Server 2005 Reporting Services, Visual Studio 2005).
As of now I can only use fields from one of my tables, or use functions within SQL DBMS. However, sometimes I wish to do more complicated things which can not be done (or at least I don't know how to do) withing SQL DBMS.
I wish to write a C# function (Web service) which takes a bunch of parameters and spits out some text. Is it possible to add a field to the report which calls this Web service, sends a bunch of parameters and displays the result of the function.
If not, Is there any way at all to manipulate some data using C# and display the result in the report.
Thanks in advance,
Any help is much appreciated
Amir
If what you are asking is "Can report items be dynamically added to a report"? then the answer is yes.
You can dynamikcally add fields to a report by loading the RDL via a memory stream to the report viewer control in local mode. Prior to loading the RDL you will need to parse the XML in order to add the the field.
