I write tools directly from Envision that allows data to be put in DataMarts, or direct EXCEL spreadsheets from the data. I then put those dumps directly on the the menus in Colleague, ans secure them to the end users. This allows the users to have access to the data they need. I am also in the process of designing a tool that will allow users to pull their own data without me writing a screen or a report for them. It is based on Colleague SECLASSes, DEPTS, and override access. It looks at the data you have available to you thru the screens you have security for and allows you create reports from that data.
The DataMart, and the direcrt EXCELs are very useful for our campus users, and the people love to be able to pull their data when they need it.