If you are familiar with writing stored procedures for your database Scolo has the ability for you to create custom reports. A custom report will allow you to use data from other sources and combine them with information Scolo’s database.

The custom report engine in Scolo allows you to ask for specific variables from the user to use as input criteria for your stored procedure. If you want to use input parameters see the section describing all available input parameters. If your procedure does not have any input parameters then you can ignore that section.

Included in this help file is a section on how insert a new custom report into the database. In that section is an example for creating a very simple sample procedure and then setting up the custom report in Scolo’s database.

Note: All custom reports should be inserted into the database under the category for ‘Custom’ reports. Future updates to Scolo may manipulate or delete database records for Scolo’s reports but will not touch any reports that are in the ‘Custom’ reports category. This will make more sense after review the following sections.

Obviously to be able to create a custom report you need to have permissions on the database for creating procedures and modifying table contents.