ID900 - Instructions for Running SSRS Report

Like the mapping application ID900 is a SQL Reporting services report and will be available in a folder at a web address.

Click here for instructions on launching the report.

You must have eAutomate security rights to be able to view GLReports in eAuto.

All our SQL Reporting Services (SSRS) reports will be located in this folder, look for ID900.

Report Filters:

1. Month: Note when selecting the date range that our report runs by period, but we show the date as Month - Year so it's easier to understand. 

Please also note each time you access the report it will be set with dates where you left off last time you ran the report. So...

A-if you find discrepancies go back to mapping to fix and update again

and/or

B-if it has been some period of time you still must go back to mapping and review for any new account AND update the mapping to get newest info brought in.  

 

To see last years total numbers, then run thru December of last year:

2. Model - Only select SBA2019:

3. Refresh data - if any changes to mapping (ID893 Financial Mapping App) or to refresh totals for new month you haven't run for before:

4. Annual Target - you select, default is 1,680,000 

5. Financial Divisions - pulled from ID893 Financial Mapping App

6. GL Branches - select from Drop Down

THEN SELECT VIEW REPORT!

Sample:

**The Model TARGET% for GP, OP, etc does not include anything for the Managed IT 'DIVISION'. If you are truly wanting to see how your % stack up to the model targets, then you will need to run the report only for the 'Imaging' division

FYI CYTD (Current Year To Date) /PYTD (Prior Year To Date)

Employee Headcount Page from ID893 Employee Mapping Portion, see THIS LINK for that set up.