<div>
Does the BIDS have to be installed on the SQL server? &nbsp;Could I install it on my workstation and interface with the SQL server?
</div>


Does the BIDS have to be installed on the SQL server?  Could I install it on my workstation and interface with the SQL server?

<div>
Hi,<br />
<br />
No, you can install BIDS on your local machine and deploy connections, data sets and reports to the server from there.<br />
<br />
Thanks<br />
<br />
Darren
</div>


Hi,

No, you can install BIDS on your local machine and deploy connections, data sets and reports to the server from there.

Thanks

Darren

<div>
You an also use <a href="https://www.visualstudio.com/vs/" rel="ugc">Visual Studio 17</a> Community Edition, but you have to install the <a href="https://blogs.msdn.microsoft.com/analysisservices/2017/03/09/introducing-sql-server-data-tools-for-analysis-and-reporting-services-for-visual-studio-2017/" rel="ugc">SQL Server Data Tools</a> plugin separately. Bit of a pain, but then you'll be on the latest tech.
</div>


You an also use Visual Studio 17 [https://www.visualstudio.com/vs/] Community Edition, but you have to install the SQL Server Data Tools [https://blogs.msdn.microsoft.com/analysisservices/2017/03/09/introducing-sql-server-data-tools-for-analysis-and-reporting-services-for-visual-studio-2017/] plugin separately. Bit of a pain, but then you'll be on the latest tech.

<div>
<div class="content wysiwyg-content">
I have created a query/agent job and I want to turn it into a ssrs report where the user can select parameters from drop down menus.<br />
<br />
My question is, what tool should I choose to create my first report of this kind? &nbsp;It seems like all 3 below will work, (different means to the same end) I just want to pick a good one as a starter.<br />
<br />
1) Native tools on report server url?<br />
2) SSDT?<br />
3)1.BIDS ( Business Intelligence Development Studio 2010)&gt;
</div>
</div>


I have created a query/agent job and I want to turn it into a ssrs report where the user can select parameters from drop down menus.

My question is, what tool should I choose to create my first report of this kind?  It seems like all 3 below will work, (different means to the same end) I just want to pick a good one as a starter.

1) Native tools on report server url?
2) SSDT?
3)1.BIDS ( Business Intelligence Development Studio 2010)>

SSRS tools

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Analytics is the discovery and communication of meaningful patterns in data. Especially valuable in areas rich with recorded information, analytics relies on the simultaneous application of statistics, computer programming and operations research to quantify performance. Specifically, areas within analytics include predictive analytics, prescriptive analytics, enterprise decision management, retail analytics, store assortment and stock-keeping unit optimization, marketing optimization and marketing mix modeling, web analytics, sales force sizing and optimization, price and promotion modeling, predictive science, credit risk analysis, and fraud analytics.

Analytics

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.

Microsoft Server OS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.