MAS 90 / MAS 200 Custom Office/Crystal Tips and Tricks:


Providing Security to Individual Financial Reports

BY DAN BURLESON — JUNE 6, 2009

MAS 90 / MAS 200 Custom Office provides features that can easily extend the usefulness of the program.  User Defined Tables (UDTs) are one such feature.  They can be defined so that the data they hold is unique to each company, or is common to all companies.  My guide below shows how a common UDT can be used to enhance the security of the standard financial reports.

This guide will also demonstrate a feature of Crystal Reports called array variables.  Array variables are a construct that can hold a set of similar values that can be accessed individually, or as an entire set.  The existing MAS 90 / MAS 200 security treats all General Ledger financial reports the same. By loading array variables with the user login codes and report names from a common UDT, a few simple Crystal Report logic additions can use these array variables to secure users to any report by name.

Quick Reference for advanced Custom Office users
Step-by-Step instructions for experienced Custom Office users