Let’s Get Crazy with SSRS Reports: Session Review

If you are joining us for KTL’s 12th Annual Empower the User Conference this year and are interested in ramping up your reporting skills, you will want to consider attending the “Let’s Get Crazy and Customize Your SSRS Reports,” presented by Minal Wad, a KTL Senior Developer.

As a project manager and big consumer of data, I have found the need for real time, on demand data a necessity in keeping up with client needs. Minal has put together a presentation that will take you into building a fully functional SQL report from the ground up, adding customizations such as filtering, formulas, and conditional formatting.

SQL and its related dialects such as T-SQL, PL/SQL are consistently the most in-demand languages for the last several years in a wide variety of roles. It is increasingly used by business analysts in roles both inside and outside of traditional IT and CS. There is a growth in its use in financial, manufacturing, and transportation industries. This growth of SQL as the lingua franca of databases is such that its competitors will most likely outpace any new or growing platform that wasn’t included in its data management methodology in no uncertain terms.

SQL Server Reporting Services or SSRS is also growing in form and function as well.

When sitting in on her test run this week, one of the things I noticed was how powerful the design aspect of SSRS is. There are so many comparisons to Excel that many people will find it a comfortable dip in the pool. If you consider yourself an expert in Excel, this is the next logical skill to add to your toolbox.

The presentation is going to be primarily demonstrative. Minal will essentially build the report from the ground up, adding functionality as it is built. Additionally, she will show advanced customizations.

Minal is going to cover the following topics:

  • SSRS reports – what they are and why should we use them.
  • The advantages of using SSRS with GP
  • Building a report in 60 seconds
    • Data sources
    • Tables and fields
    • Parameters
  • Hands On Customizations
    • Grouping
    • Drill Down Reports
    • Sub-Reports
  • Useful areas to Customize
  • Advanced Customizations
  • New and interesting features in SSRS 2016

So making that jump from Access or Excel can be intimidating, but this presentation will be key in helping you decide how and when to make that leap and to do so knowing you have a solid foundation. If you are curious about KTL’s User Conference, what other fantastic presentations we have to offer, and have not signed up, I encourage you to contact us today at info@ktlsolutions.com or check out our event page on our website, here.

Have you used SSRS in your day-to-day role? Are you curious about how it can help you? Have any thoughts or comments; I’d like to hear from you. jchamberlain@ktlsolutions.com


JEFF L. CHAMBERLAIN, PMP | Project Manager

Jeff comes to KTL Solutions with an extensive background in healthcare IT, technical consulting, and telecommunications. He has been a project manager for almost 20 years, holding certifications from the Project Management Institute as a Project Management Professional, from the Management and Strategy Institute as a Six Sigma Lean Professional, and he holds a Scrum Master Certification from the Scrum Alliance. He has managed both hardware and software implementations for both the government and private sectors, in industries such as healthcare, insurance, telecommunications, staff augmentation, supply chain and shipping.

Jeff has provided training for clients globally, working in Europe, Russia, North and South America on various topics from system optimization to wireless theory and design. He possesses a Bachelor’s Degree in Technical Writing from the University of Baltimore.