Reporting Services 2014 and Windows 10: The way out

Microsoft Edge, or simply Edge is the default browser in Windows 10. It is not designed to start with elevated permissions.

Reporting Services Server is accessed in the default Edge browser and you always end up with access denied for the user, <domain>/<User> for lack of sufficient permissions. One could use another browser such as Firefox but Reporting Services server cannot be accessed even when the browser is launched with elevated permissions. Firefox did not have problems in accessing the Report Server in SSRS 2012.

The way out for this in using the IE 11 browser that comes with Windows 10.

Hands-on Learning Event in Honolulu 2, Nov 5, 2015: SQL Server Reporting Services 2012

The class is forming and is expected to start on November 5, 2015. Please register at the PCATT.ORG site.

Adata/Pcatt1.png
SQL Server 2012 Express or Developer Edition / Evaluation edition will be used. The emphasis is on Native Mode operation of the Reporting Services.

For details you can also write to:
Hodentek@live.com with course name in the Subject line.

Here are Reporting Services books published by the instructor:

You can buy these and many other computer and programming related books here:

https://www.packtpub.com/books/info/authors/jayaram-krishnaswamy

Hands-on Learning Event in Honolulu 2: SQL Server Reporting Services 2012

The class is forming and is expected to start in August 2015. Please register at the PCATT.ORG site.

SQL Server 2012 Express or Developer Edition will be used.

For details you can also write to:
Hodentek@live.com with course name in the Subject line.

Here are Reporting Services books published by the instructor:

 

 

You can buy these and many other computer and programming related books here:

https://www.packtpub.com/books/info/authors/jayaram-krishnaswamy

 

 

SQL Training and SQL Server Reporting Services 2012 training in Honolulu

These are the training schedules for the2nd Quarter of 2014 at the Pacific Center for Advanced Technical Training (PCATT). There are two courses that you may be interested in, it is recommended that they are taken in the order shown to reap maximum benefit.

You can also access the reviews of the previous session in 2013 at the PCATT site.

Introduction to Structured Query Language (SQL)

 

SQL Server Reporting Services 2012: Native Mode Implementation

Please register with  http://pcatt.org/registration    or send an email to gcerny@hawaii.edu

Download this SQL Server 2014 CTP2 Reporting Services Add-in to integrate with Microsoft SharePoint

Report Integration for SQL Server 2012 and SharePoint 2010 was described comprehensively in my latest book:

The new features Power View and Data Alerts were treated in two complete chapters:

Chapter 6: Power View and Reporting Services
Six hands-on exercises

Chapter 7: Self service Data Alerts in SSRS 2012
Three hands-on exercises

The SharePoint 2010 used in the book should work equally well with SQL Server 2014 CTP2.

SQL Server 2014 CTP1 installation was described here.
http://hodentekmsss.blogspot.com/2013/09/installing-sql-server-2014-ctp1-on.html

Programs have been updated and new versions have appeared.
SQL Server 2014 is now in CTP2

Now how does one start working with features like Power View and Data Alerts?

You need to install and work with recent versions.

You need the following :
Microsoft® SQL Server® 2014 Reporting Services Add-in for Microsoft SharePoint®, Community Technology Preview 2 (CTP2)

You can download the above from here:
http://www.microsoft.com/en-us/download/details.aspx?id=40738

Details from the above site are here:

·         The SQL Server 2014 CTP2 Reporting Services Add-in for Microsoft SharePoint technologies deploys the Reporting Services user interface pages and features on a SharePoint web front-end server.

• The SQL Server 2014 CTP2 version of the Reporting Services add-in supports SharePoint 2010 and SharePoint 2013.
• To use connected mode features of Reporting Services with the 2014 CTP2 add-in, the report server version must also be 2014 CTP2 version.
• For more information on supported versions, see “Supported Combinations of SharePoint and Reporting Services Components”.
• For more information on Local mode and connected mode, see “Use Access Services with SQL Reporting Services”.

After you install the Reporting Services Add-in and configure your servers for integration, you can publish Reporting Services content to a SharePoint library and then view and manage those documents directly from a SharePoint site. The Reporting Services Add-in provides the following functionality:

• Power View, a feature of Microsoft SQL Server 2014 CTP2 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition, is an interactive data exploration, visualization, and presentation experience. It provides drag-and-drop ad hoc reporting for business users such as data analysts, business decision makers, and information workers. Power View reports are in a new file format, RDLX.
• Open reports in Report Builder from a SharePoint library, and save reports to SharePoint libraries.
• A Report Viewer Web Part, which provides report-viewing capability, export to multiple rendering formats, page navigation, search, print, and zoom.
• SharePoint web pages so that you can create subscriptions and schedules, and manage reports and data sources.
• Support for standard SharePoint Foundation 2010 and SharePoint Server 2010 features including document management, collaboration, security, and deployment with report server content types.
• The ability to add the Reporting Services Report Viewer Web Part to any page or dashboard on a SharePoint site and customize its appearance.
• The ability to use SharePoint permission levels and roles to control access to report server content. You can also use SharePoint forms authentication to support access over Internet connections.
• Reporting Services data alerts, a data-driven alerting solution for SharePoint Server 2010 Enterprise Edition that informs you about changes in report data that are of interest to you, and at a relevant time.

 

First step in report authoring: Connecting to a source of data

Report authoring is perhaps one of the most frequently required activities in an enterprise. Knowledge of report authoring is an invaluable asset when one is looking for a job in an enterprise. Before you can write a report you will have to know where your data is and how to get connected to it from your authoring software. Report authors who are not very comfortable with using data on a back end server could use the more powerful and highly interactive Power View reports, but this requires a developer in your organization to create a model for you to work with. Once the model in place it is super easy to create stunning reports. This is only possible on SQL Server 2012 with the reporting services installed in SharePoint integrated mode.

The following is specific to SQL Server Reporting Services, but this is important for any authoring tool. In the following Visual Studio 2012 is presumed and a web project is to be created to demonstrate the use of Report Viewer Control.

Presently the Server Explorer has the following items:

 

If you do not see Server Explorer you click View in the main menu and click Server Explorer as shown:

Presently there is a connection established with the Adventure Works 2012 database on the SQL Server 2012 named Kailua.

Click Connect to Server item on Server Explorer tool bar shown.

The Add Server window is displayed as shown.

The name of the computer is provided (you provide the name of your computer). Click OK.

Adding a Data Connection

Click Connect to Database toolbar item as shown.

Or you can right click Data Connection and start as well.

Assume that we clicked Connect to Database.

The Add Connection window is displayed as shown.

This is because before getting to the database you must first get connected to the server. Notice that the Microsoft SQL Server (SqlClient) is the default. It can be changed to others by hitting the Change... ellipsis button and following the wizard.

For now accept the default. Click on the handle for Server Name after hitting the Refresh button. You see three servers, a SQL Server 2012 (Kailua); a SQL Server 2008 R2 (Maui) and a SharePoint Server.

Click HODENTEKWIN7\KAILUA to choose the server. The Add Connection window is updated as shown. We accept the default authentication, Windows Authentication.

Click on the handle for the Select or enter a name for the database field to display the drop-down list as shown.

Click Northwind. It could be another database in your case. Click the Test Connection button and verify that the connection was successful as shown.

Click OK on the above message window and click OK on the Add Connection window. The new database connection will be added to the Visual Studio 2012’s Server Explorer as shown.

That is all for now.

Mahalo

My new book uses images / screenshots such as the above to guide you through the learning process. The instructions are very simple and most of the steps are described.

http://www.packtpub.com/learning-sql-server-2008-reporting-services/book

http://www.packtpub.com/learning-sql-server-reporting-services-2012/book