I want to pass the excel file name in a text box and then want to create a report from the data available in that file.What i want is to create the report dynamically according to the file name in textbox.How can i do it??
It is possible to build a report that takes a parameter value to construct all or part of a datasource. If it is only the filename that is changing then it will be one parameter, if more details are different then you will need a parameter for each difference. You wont be able to control the error handling very well so your users could get ugly error messages if they provide a value that isnt valid. This is a good start for you http://msdn.microsoft.com/en-us/library/z72eefad.aspx
No one has followed this question yet.