asked on

How to use SSRS in Visual Studio 2015

I have updated Visual Studio 2015 with SP 3 and added SSDT. Task Mgr shows Reporting Services - SQL Server Reporting Services. In VS 2015, I don't see SSRS. How can a report be made part of a Windows Form app? Or is the only way to do reporting is by using SQL Server Express? But, I don't see how to use SSRS from SQL Server.
Need a lot of instruction here.

Barry

ASKER CERTIFIED SOLUTION

John_Vidmar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Chinmay Patel

Hi Barry,

Here are the answers
1. It is already answered by John. New Project -> Installed -> Templates -> Business Intelligence -> Reporting Services should give you two starting points a.) Report Server Project Wizard b.) Report Server Project. If you are new to report development, I suggest you try both.
2. To answer your second question, how can a report be made of a WinForm app, please have a look at: https://docs.microsoft.com/en-us/sql/reporting-services/application-integration/using-the-winforms-reportviewer-control?view=sql-server-2017

Regards,
Chinmay.

Barry Dunlap

ASKER

Thanks for responding. I stopped using SSRS because it would not deal with a 7-table join where a few column names are the same in different tables. Evidently SSRS requires that aliases must be used on each of the same-named columns. Doesn't SSRS consider the table name?

I quit using SSRS and will try Access in Office 2010 Pro for writing a report.

I installed Crystal Developer in Visual Studio 2015. It too was a disaster. Using only 1 table which contained the columns and values from that 7-table join I mentioned, CR found the column names in order correctly, but the values came from some source not even in the database. Must be that it too complex to integrate CR into Visual Studio 2015.

I added my experience with reporting for you info. You might want to pass this around.

Barry Dunlap