This is not a built-in function in Reporting Services. You could use Custom Assembely. Custom Assembely is a set of code you deploy in the system and reporting services will use the function inside to get the name you need. You may ask your friends who knows C#or VB.net for help :) http://support.microsoft.com/kb/920769 http://msdn.microsoft.com/en-us/library/ms155034.aspxYao Jie Tang -Microsoft Online Community

Hi, I have a requirement in SSRS report where .Net code has to be included. In my report I am showing the path for a batch file (depending upon the filters used, the batch file path may vary). The requirement is , I want the SSRS to open the batch file and find the package name inside it and return. Is it possible? If,so what are the steps? where should I add the code and how? Could you please give the codes in detail as i don't even know the abcd of .Net Thanks in advance!

This is not a built-in function in Reporting Services. You could use Custom Assembely. Custom Assembely is a set of code you deploy in the system and reporting services will use the function inside to get the name you need. You may ask your friends who knows C#or VB.net for help :) http://support.microsoft.com/kb/920769 http://msdn.microsoft.com/en-us/library/ms155034.aspxYao Jie Tang -Microsoft Online Community

Hi Revathy I am not sure of writing dot net codes in SSRS. I have not worked on batch file but something like opening a text file through ssrs, hope you will get some idea through this : Here are few steps how you can do it in ssrs. 1. The value of the path in database should be some thing like the name of the file. For Eg : 'testing.txt' 2. All the files for different filters should be hosted on a web server or in a database. 3. Suggest you not to use the local path as this might lead to various security issues Eg : Read permission etc. 4. Write the expression in the textbox where you are getting the text file name as some thing like this ="http://myserver/share/" & Fields!TextFileName.Value 5. Right click the text box where you write this expression and select textbox properties. 6. Go to Action in the text box properties and select go to url and write a expression ="http://myserver/share/" & Fields!TextFileName.Value After this when you run the report you will be able click on the path and this will open the text file that you have hosted on the webserver. This is just a idea to get you going with your batch file thing not an exact solution to your problem. Hope this helps. Regards, P.Anish Shenoy. "Mark this post as answer if this post helps you it might help others also"