Geek Answers Handbook

Can I create SSRS reports in VS 2015 using SQL Server 2008 R2?

I am new to SSRS.

Recently updated my development environment from Visual Studio 2010 to Visual Studio 2015 Enterprise Edition. My reports are currently compiled using Crystal Reports. I would like to use SSRS, and I'm trying to find out if my current environment will allow me to do this.

So now I am using Visual Studio 2015 and SQL Server 2008 R2.

  • Can I create SSRS reports using these two?
  • If so, how can I create it?
  • I know how to create a report and publish it using Business Intelligence Development Studio in SQL Server 2008 R2. But I could not understand how I could use these reports in my WebApplication project in Visual Studio 2015.
  • I would also like to know - is it possible to reuse my existing datasets that I use in my Crystal Reports?
  • Should I upgrade my version of SQL Server?
+8
source share
2 answers

Yes, you can create reports for SSRS 2008 R2 with VS 2015. You will need to download and install SQL Server Data Tools (SSDT) ​​from the following link.

https://msdn.microsoft.com/en-us/library/mt204009.aspx

To create reports, create a new project using the report server project template found in the Templates / Business Intelligence section of the New Project dialog box. (After installing SSDT)

This is a replacement for BIDS, so much of what you see should look familiar. Not sure about Crystal Reports datasets, but you should be able to reuse any SQL or stored procedures that may be part of them.

Should you upgrade? At some point, of course, but it is not required. SQL Server 2016 is about to be here, and you are working with a product that is more than 4 years old, and most likely will soon come out of support if it has not already been.

+8
source

There is a setting in Visual Studio (see above for details).

There is a setting in

Project --> Properties --> TargetServerVersion

Please note that here server means a database server or db server, not a web server or report server.

But note: for me this is only the version in the folder:

 ..Projects\myProject1\myProject1\bin\Debug

it will actually deploy and work.

0
source

More articles:


All Articles