Archive | February 2015

March 2015 Speaking Engagements

Next month I will be teaching two different sessions on SSRS. One will be in a workshop setting where you can learn some advanced SQL Server Reporting Services (SSRS) skills. This will be in Atlanta Georgia that I will be co-teaching with Devin Knight. These sessions are designed for someone who already has some experience with SSRS. This isn’t a beginner session for someone new to SSRS. However, the other will be a virtual class that will focus on ramping up your SQL Server Reporting Services (SSRS) skills for anyone new to SSRS.

image001

The first one is an in person workshop at the Microsoft office in Atlanta, GA. The workshop is only 2 days long (3/10/2015 – 3/11/2015) at a very affordable price, $399.

Overview: Master Report Developers must hold unique traits to set themselves and their work apart from others. This two day class is designed to take you to the next level in your understanding of SQL Server 2008R2/2012 Reporting Services (SSRS). You will learn how to create complex reports that use Analysis Services as a data source and custom code assemblies. This course will cover all the advanced topics of Reporting Services like scaled-out deployment, .Net integration and monitoring Reporting Services usage. This class is built to work for students using one of the following versions of SQL Server: 2008R2/2012/2014. Audience participation is encouraged so bring your laptop ready to go with the system requirements below.

This facility can only hold a maximum of 60 people. So sign up ASAP before it’s full. For more details or to register please go to the link below.

https://pragmaticworks.com/Training/Workshops/Data-Visualization/Schedule/3-10-2015_AtlantaMasterSSRSWorkshop

image002

The other session is a virtual session that can be attended from anywhere in the world. I have had people from Asia, Africa, and Europe attend this class virtually without any issues. This is a 4 day class (only half days) that will be on 3/16/2015 – 3/19/2015 from 2-5 EST. The great thing about this class is that you have access to the recordings for up to 7 days after the class for reference and 2 hours of our BI Virtual Mentor service for assistance with YOUR project work.

Overview: This is a four day class designed to help you understand all aspects of SQL Server Reporting Services (SSRS), the reporting tool of choice for SQL Server developers. We will use a variety of lab exercises and small projects to ensure you gain familiarity in how the design and execution environments work and to prepare you to build your own real world applications using this SQL Server subsystem. With the hands-on labs, you will learn how to create complex reports. This course will cover all the key concepts of Reporting Services from basic reporting, parameters, deploying, and scheduling.

For more details or to register please go to the link below.

http://pragmaticworks.com/Training/VirtualTraining/Data-Visualization?Schedule=9-12-2014_PragmaticSSRS(Online)

SSRS Repeating Page Headers: Option 3

This is the third post in this series where I have shown you have to resolve this issue in SSRS. Check out my other 2 blogs on this same subject, you can find those links posted below for additional workarounds.

This third option here is probably the easiest to work with or at least start with. If you don’t like altering the XML of a report or going into the advanced group settings you also can start the report using the SSRS report wizard. That’s’ right, if you create a report using the SSRS report wizard it will automatically setup the report to use repeating page headers. If you don’t believe me go give it a try.

image002

After you have done this you can go look at the XML of the report and you will see the XML settings and how it has been setup to get these feature working. Go check out my second blog in this series to how this can be done.

 

Option 1 https://chrisalbrektson.wordpress.com/2015/01/15/ssrs-repeating-page-headers-option-1/

Option 2 https://chrisalbrektson.wordpress.com/2015/01/26/ssrs-repeating-page-headers-option-2/