Report parameter problem

Question

User880505331 posted

Hi,

I'm trying to create a filter parameter like in this tutorial

https://www.youtube.com/watch?v=c9bOO109bY8&index=11&list=PL7A29088C98E92D5F

In the tutorial the parameter is visible in the report and the users can modify it.

Tutorial - Add Parameter Screenshot

but when I try to create parameter i have less option.

My VS add parameter screenshot

I'm using visual studio 2013 pro.

Someone can help me please?

Answer 1

User-2057865890 posted

Hi Lucas,

but when I try to create parameter i have less option.

You could use Report Builder or SQL Server Data Tools (SSDT).

With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio. 

Best Regards,

Chris

Answer 2

User880505331 posted

Thank you very much. In SSDT I have all the option I was serching for.

In Visual Studio is not possible to have the same option? Like parameter prompt?

Answer 3

User-2057865890 posted

Hi Lucas,

If you do have Visual Studio 2015 Community Edition (or above) installed on your machine, installing SSDT will add the full set of SQL Server tools into your existing Visual Studio installation. Visual Studio includes many features you might want to use, such as Source Code Control integration and non-SQL language support.

reference: https://docs.microsoft.com/en-us/sql/reporting-services/tools/reporting-services-in-sql-server-data-tools-ssdt

Best Regards,

Chris