Hi All, I need some info on SSRS... .Here goes my scenario... I am creating a report using Business Intelligent Development Studio(sql servcer 2008) and not Visual Studio .The Report datasource is XML. I have created an XML file in my project with Fields like EmployeeNo,EmployeeName,Designation and DOB. I am able to pull all the fields data from this XML to report. Now I want to pull only EmployeeName,Designation and DOB fields based on EmployeeNo. Here I want EmployeeNo to be my parameter. Can anyone help me to know how we can apply Parameters when the datasource is an XML file and not sqlDB. Regards Usha Thnx Usha

You can create parameters in Report itself if they are not coming from SQL Query and map them to the field whatever you want to. Go to Reports>report parameters form main menu.

Hi Usha, From your description, the EmployeeNo parameter's values are get from the same XML file. Then you want to use this parameter to filter the dataset. If I understand correctly, we can following these steps tp accomplish the target: Create one new same dataset. This new dataset has the same query with the original one. Create the parameter EmployeeNo. Set its value from the original dataset. Now, double-click the new dataset. Go to 'Filter' page, and then add a new filter. Set the expression of the filter to be the value of the parameter. For more information, please see: How to: Add a Filter (Reporting Services): http://msdn.microsoft.com/en-us/library/ms156270(SQL.100).aspx If there is anything unclear, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

Hi All, Thanks for the reply that worked for me... Thanks Usha Thnx Usha