Hi, I am creating a Report using SSRS (BIDS). Is there a way where i can add controls like Button,Dropdownlist etc.I am not using any .NET code and developing my report using BIDS. Thanks Usha Thnx Usha

no there are no buttons and drop down lis in SSIS body, can you please elaborate your requirement may be you can use some image and use drill down functionality ... Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

Hi Gaurav, My report has a header below which i want to place 3 dropdownlist and a button. I need to link the datasource of this dropdown to a dataset. When the user selects the values and click on the button i need to show the data related to these inputs that we get from dropdown list. Currently i am using report parameters to display this dropdown ,but these will be displayed at the top of the report but iwant to place them after my header. Thanks Usha Thnx Usha

Hi Usha, As you already achieved, currently the only way is to use parameters. However, if it is necessary for you to place the parameter area below the report header, please submit your suggestion at https://connect.microsoft.com/SQLServer/. If the service requests frequently, we may include it in the next release. Thank you for your understanding. If you have any more questions, please feel free to ask. Regards, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help

Hi Tony, Thanks a lot for the reply. UshaThanks Usha