Creating and Editing Reports

Crystal Reports 2008 is required to edit existing reports or create new reports to add to the Astra Schedule system. A new Crystal Report file (.rpt) can be uploaded to Astra Schedule and made available to users through the application. (See “Upload Reports” for instructions.) Please consult Crystal Reports help for more information on generating and editing report files.

 

Reporting on Astra Schedule data is supported through the generation of reporting-specific database views. These report views (labeled “...ReportView”) combine data from various database tables to provide access to application data in a more report-friendly way. Additionally, when the Astra Schedule database is initially created during installation, a report database user (“AstraReports”) is created that has access only to these report views. This is the database user that is used by the application to get data for report population. Providing the AstraReports database login to a Crystal Reports user will also limit the list of available tables, making report editing and creation simpler, and ensure that any new report information is available from within the application.

 

Report data security is achieved through the use of special report views that include the list of event, section and resource records that can be viewed by individual users. By linking these “accessible” report views to their respective report data views in the report and imbedding a “User ID” parameter, user security is applied to the report. This specific parameter is intercepted by the Crystal web viewer and the user’s ID is passed in to the report automatically. See the Astra Schedule default report list for examples.

 

Connect to the Astra Schedule database with Crystal Reports to access these views and fields as needed.

Page url: ?reporting_creatingandeditingreports.htm