The investment in Seagate's Crystal Reports for Version 6 and up can be leveraged not only by allowing the reports to be selected within an application, but can be changed by super users to meet changing requirements and answering "what if" questions, without having to design, develop and deploy a new Crystal Report.

The Crystal Report Editor object provides an easy means of selecting a report, and changing its WHERE clause for the report instance, without permanently changing the report's program.

This object selects a Crystal Report using the OpenFile dialog control, and then parses and displays the selected report's SQL string into the SELECTFROM, WHERE, and ORDERBY (which includes HAVING and GROUPBY declarations in their native order) clauses into a memo edit box. The WHERE clause can be modified as needed, and the report can be run. The form includes a TCRPE object that is used to run the report for either preview, printing, or when sent to a file as a specific type (e.g., HTML, Excel, Word, even eMail).

Several security features are available as properties that restrict the directory view and selection of a report.

This object requires the SQL Parser object to be part of a project.