Introduction to SQL Server Reporting Services (SSRS) with iMIS

This online workshop gives you the skills and resources you need to use SSRS to present data from your iMIS database. You will learn how to use SSRS to connect to your database and write reports from a variety of business areas. This workshop combines lecture, hand-outs, and hands on labs with time for questions. Each attendee will have their own image on which to work.

At the end of the class, attendees will have an understanding of

  • ODBC database connectivity technology
  • Visual Studio
  • iMIS data structure
  • Data sources
  • Report formatting

  • Course Syllabus

    Session 1

    Introduction to SSRS Reporting
    • Overview
    • Using Visual Studio
    • Creating a new project
    • Adding reports to iMIS
    • Navigating your project
    • Creating a basic report
    • Formatting a report

    Session 2

    Building an SSRS Report
    • Review
    • Modifying a datasource
    • Renaming fields
    • Reformatting fields
    • Grouping your data
    • Adding summary fields

  • Course Summary

    Topics of Focus:

    • Using Visual Studio
    • Configuring iMIS as a data source
    • Creating reports
    • Formatting reports for presentation
    • Adding reports into iMIS

    Target Audience:

    This course is designed for:

    • Report writers
    • Data owners
    • Intermediate/advanced users of iMIS

     

     

    Delivery:

    At Your Desk
    (online and instructor-led)

    Duration:

    2 two hour sessions (4 hours total)

     

     

    Prerequisites:

    • Good knowledge of core iMIS functionality
    • Introduction to iMIS for Association or Fundraisers

     

     

    Voucher Pricing:
    ASI Training Vouchers

Course Dates

Upcoming DatesTimeRegionRegister
16 Sep 201910:00:00 ESTNorth AmericaregisterSSRAY0819
26 Sep 201914:00:00 AESTAsia-PacificregisterAPSRSI0819
02 Oct 201910:00:00 GMTEuroperegisterUKSRSI1019
23 Oct 201914:00:00 ESTNorth AmericaregisterSSRAY1019
11 Nov 201910:00:00 AESTAsia-PacificregisterAPSRSI1119
04 Dec 201910:00:00 ESTNorth AmericaregisterSSRAY1219

Pricing Matrix

This course is a 2 session At Your Desk course.

  Early Reg.* Regular Reg.
Global 2 vouchers ** 2 vouchers **
US $520 $550
Canada $520 + tax $550 + tax
Asia-Pacific $520 + tax $550 + tax
Europe £310 + tax £350 + tax
*The early registration period ends 2 weeks before the start of class.
** Vouchers provide a greater discount than even early registration and can be used globally for any class by anyone in your organization.

Printable Brochure