Reports
- Robert Lenk
- Miranda Thomas
- Bryan Riddle
About reports
Campus Cafe provides many ways to retrieve data from the system. The method you choose depends on the your business need and your access.
It’s important to recognize that reporting needs and methodologies vary from institution to institution. Even for common reports such as IPEDs, institutions often approach gathering the data differently depending on their unique processes or rules.
People finders
People finders allow you to build an ad hoc report by setting filters. For example, you could find all students with a home address in Rhode Island. The results may be downloaded to Excel for further analysis.Â
Refer to the People Finder documentation and the Student Finder documentation for additional information.
SSRS reports
Campus Cafe delivers base reports written in SQL Server Reporting Services (SSRS). These reports usually involve complexity that a people finder isn’t equipped to handle. For example, a base report may show you the amount of outstanding tuition receivables by aging period.
Access base reports
Gp to Faculty/Staff > Base Reports.
Log in with your institution’s server credentials.
A list of folders appear organized by functional category. Click a folder.
Click a report.
In the Database Code enter the institution's Campus Cafe issued database code.
Set any other criteria.
Click View Results.
Custom SSRS Reports
Campus Cafe, by request, will provide a copy of the database to your institutions. Customers may write their own SSRS reports and run them against a daily export of the database or request that Campus Cafe install them in base reports.
Link Permission
When the link to the base reports has been added to Faculty/Staff, the CUSTOM_FAC_LINK permission controls the links appearance in the menu for users.
