Hands-on training event in Honolulu: SQL Server Reporting Services 2012 in Native Mode

This hands-on course will provide you with the ability to create cutting edge reports using Microsoft's latest reporting services product, SQL Server 2012.

The course is offered by the Pacific Center for Advanced Technology Training(PACTT): http://pcatt.hawaii.edu/home

Report writing is one of the most important IT related jobs in an enterprise. This course is for you if you would like to master report writing/authoring using SQL Server Reporting Services. The course begins with a presentation of essential technical background, after which you will work through guided hands-on exercises.
At the end of the course you will have gained:

• A solid understanding of how to interact with SQL Servers
• Knowledge and experience installing and configuring reporting Services
• A working knowledge of using Report Builder to author reports and deploy them to report server
• A working knowledge of Report Manager's ability to carry out administrative tasks related to all aspects of reports; creating shared data sources, folder and folder hierarchies on the report server, and report models; managing security and subscriptions; and configuring data driven subscriptions
• An understanding of how to embed report viewer controls in windows and web projects.

Venue: Honolulu Community College Honolulu Community College
874 Dillingham Blvd Honolulu, HI 96817-4598
Phone: (808) 845-9211
Official Website: honolulu.hawaii.edu/

Section 1 - Mar 22 - Apr  28, 2016; TTh; 5:30 pm - 8:30 pm; 12 mtgs

I will be using my latest book on SQL Server Reporting Services for this course:

More here:http://hodentekmsss.blogspot.com/2014/11/things-you-learrn-hands-on-in-my-book.html

SQL Training in Honolulu: SQL Server Reporting Services 2012

This is a comprehensive, hands-on course. The above course will be offered as a non-credit course by the Pacific Center for Advanced Technology Training

 Course summary:
SQL Server Reporting Services 2012
Report writing is one of the most important IT related jobs in an enterprise. 
Among the BI stack components the component that provides most employment is Reporting 
Services.

This course is for you if you would like to master report writing/authoring 
using SQL Server Reporting Services. The course begins with a presentation of 
essential technical background, after which you will work through guided 
hands-on exercises.

You will start off learning the details of installing SQL Server 2102 
Developer edition and configuring Native mode Reporting Services. For 
authoring reports and interacting with reporting services you will also learn 
how to install and work with Report Builder 3.0. This is essential for 
deploying authored reports to report sever.

Report Manager the web front end is an essential part of Reporting Services 
2012 and you will learn a comprehensive set of tasks that you can carry out.
A working knowledge of Report Manager's ability to carry out administrative 
tasks related to all aspects of reports; creating shared data sources, folder 
and folder hierarchies on the report server, and report models; managing 
security and subscriptions; and configuring data driven subscriptions is 
essential for managing reports.

Many applications depend on embedding these reports so that the user has the 
opportunity to view these reports. To this end, an understanding of how to 
embed report viewer controls in windows and web projects is essential. You 
will learn the basics of creating these applications.

During each meeting the students will be assessed for their knowledge, 
competency and proficiency in installing, configuring, authoring, deploying, 
and managing reports.

The hands-on exercises will draw largely from the authors first and second editions of his book on SQL Server Reporting Services 2012.

 

and the first edition related to SQL Server 2008

 

Course schedule: 

Feb 3 - Mar 17, 2014; Mondays and Wednesdays; 5:30 pm - 8:30 pm; 12 meetings

Location:
Honolulu Community College

Report Builder Report using data from SQL Anywhere 16

Report Builder 3.0 is the present version shipped at the same time as SQL Server 2012. It is a one-stop report authoring tool which can even be launched from Report Manager or from a Reporting services Integrated SharePoint Site. Of course you can download and launch it after installing on your desktop.

The most viewed Report Builder tutorials are here:
Report Builder is described in great detail here:

http://jayaramkrishnaswamy.sys-con.com/node/982742
Creating reports using Report Builder 2.0 is described here

http://jayaramkrishnaswamy.sys-con.com/node/1227111

 

You can master Report Builder 3.0, just follow the step-by-step instructions

Report Builder 3.0 is described exhaustively in my latest book

Out of the box it can connect to a variety of vendor products and the inclusion of ODBC and OLE DB makes it extremely convenient to connect to many other (not out of the box supported) products

Case in point is SQL Anywhere Server 16 for which you can set up an ODBC connection

This post shows you some of the steps that you can follow to turn out a report from SQL Anywhere 16. The following assumes that you have already started the SQL Anywhere Personal server. The procedure has still some unanswered questions, please read the last section

The following screen shows how you connect to an ODBC source for a connection embedded with the report

The next slide shows an ODBC System DSN 'demo' created using the SQL Anywhere 16. In reality this ODBC DSN gets registered when you install SQL Anywhere 16

 The next slide shows that connectivity is OK with 'dba' as username and 'sql' as password

The final connectivity screen after testing the authentication is shown in the next image

 The Credentials for this connection are shown in the next image

In order to create a dataset for your report use of Query Designer is not possible as it is not supported. You need to have this information on your hand to insert into the Report Builder's data set page.

The next image shows the InteractiveSQL tool in which a SQL Select statement is used to choose a all the fields from the Contacts table.

The dataset will be created using this embedded connection as shown.

For this, the query contacts.sql created in Sybase's InteractiveSQL is used and persisted to the desktop. This is imported into Report Builder's data set interface as shown using the import button

.

The next image shows the report designer interface taking in a few columns from the data set shown on the left.

This last image shows the report being displayed in Report Builder 3.0

Caution

While the above procedure is correct you may find problems while repeating this procedure and this will be mainly due to the odbc32 and odbc64 problems as I understand it

However, take a look at my bug report to Microsoft connect here

https://connect.microsoft.com/SQLServer/feedback/details/799460/report-displays-correctly-in-ssdt-and-deploys-without-errors-the-same-report-is-not-displayed-in-report-manager-or-report-server