Crystal reports

If your school has the "Legacy" ON API and SDK, you can use Crystal reports to access SQL views via ODBC. Then, you can upload Custom reports to the Reports area of the 'Blackbaud's Education Management' products, if these criteria are also met:

• Custom reports are created in Crystal reports.

• They are saved as .rpt files.

• The .rpt doesn't tie to a local database. Instead, build .rpt files that point to an OLE DB (ADO) connection and use the Blackbaud K-12 Data Access Objects correctly.

• The .rpt is built pointing to an OLE DB (ADO) connection instead of an ODBC DSN connection.

• Create each query using the view you want. (Do not use the Crystal Database Expert and select a view.)

• Never select Save Data with Report. Instead, ensure you pull the latest data with every view of the report.

Tip: For details, refer to this document.