Topics Map > Reports

SSRS - Overview

This document will show you how to access and use SSRS.

Accessing SSRS

https://reports.swtc.edu/reports

SSRS works in all browsers including Chrome and Firefox.  SSRS is only accessible when on campus or through the VPN.

Adding SSRS to your Bookmarks (Chrome)

  1. Visit the SSRS website (https://reports.swtc.edu/reports).
     
  2. Sign in with same credentials you use to log into your computer.

    Favorites in Chrome

  3. After signing in, you will see the SSRS dashboard.

  4. To add this link to your favorites, click on the star on the right side or the URL bar in Chrome.

    Favorites in Chrome

  5. Rename the link to "SSRS" and add it to the folder you like.  Adding it the "Bookmarks bar" will provide easy access.

  6. Click Done.

    Bookmarks

  7. You should now see the new bookmark to SSRS in my bookmarks bar.

    SSRS Bookmarks

  8. If it does not show up on the bookmarks bar, it may be that you are not “showing” your bookmarks bar.  To show your bookmarks bar:

    a) Click on the "3 dots" on the top right or your Chrome window.
    b) Hover over "Bookmarks".
    c) Click "Show Bookmarks Bar".

    Show Bookmarks

SSRS Favorites

A new feature in SSRS is “Favorites”.  This allows you to keep all of your commonly used reports in one folder.

  1. To add a report to a Favorite, click the 3 dots on the top right of a report and then click "Add to Favorites".

    Add Favorite in SSRS


  2. You can now click your Favorites folder to access any of the reports you have added.

    Access Favorites

SSRS Subscriptions

Another feature of SSRS is the ability to create subscriptions.  Subscriptions allow you to email yourself (and only yourself) a report on a schedule that you determine. 

  1. To create a subscription, click on the 3 dots on the right side of a report.

  2. Click "Manage".

    Click on Manage

  3. Now click on "Subscriptions".

    Subscribe
  4. Click on the "Edit Schedule" link.

    Edit Schedule

  5. On this screen you can schedule the days and times you would like to receive this report.  You can also select start and end dates.

    Edit Schedule

  6. When done click "Apply".
  7. This will take you back to your original screen.  You will see at the top the schedule you have created.

  8. Enter your email address (a reminder that you can only email this to yourself).

  9.  Enter the parameters of the report.  In the drop downs select those parameters.

  10. When all options are selected click "Create Subscription".

    Create Subscription


Keywordsmrs,ssrs,report,reports,sql,report   Doc ID91505
OwnerJohn T.GroupSWTC
Created2019-05-03 09:18:57Updated2024-09-03 08:00:01
SitesSouthwest Wisconsin Technical College
Feedback  0   0