How to use SSRS in Visual Studio 2015

Barry Dunlap
Barry Dunlap used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
In VS2015, create a project, Reporting Services template is found under Business Intelligence.
Chinmay PatelChief Technology Ninja
Distinguished Expert 2018

Commented:
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.

Author

Commented:
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial