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
24 Oct 201812:00:00 AESTAsia-Pacificemail us to register
12 Nov 201810:00:00 GMTEuropeemail us to register
15 Nov 201814:00:00 ESTNorth Americaregister
13 Dec 201810:00:00 ESTNorth Americaregister
31 Jan 201910:00:00 GMTEuropeemail us to register
11 Feb 201914:00:00 ESTNorth Americaregister
14 Mar 201910:00:00 ESTNorth Americaregister
08 Apr 201914:00:00 ESTNorth Americaregister
24 Apr 201910:00:00 GMTEuropeemail us to register
13 May 201910:00:00 ESTNorth Americaregister

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