Crystal Reports Templates

Crystal Reports is a business intelligence application used to generate reports and dashboards with data from various sources. MineMarket uses Crystal Reports templates to generate reports.

A Crystal Reports template defines the layout and formatting of report outputs, including elements such as page layouts, text fields, logos, headers and footers, font styles, and other document properties.

Creating a Crystal Reports template involves:

  1. Specifying the data source for the report template
  2. Adding tables to the report template

Note: How to use Crystal Reports to create templates is outside the scope of the MineMarket documentation. Contact your Datamine representative for assistance with creating reports for MineMarket.

The database connection to access the data for the Crystal Report can be via:

  • Access/Excel (DAO)
  • ADO.NET (XML)
  • Database Files
  • ODBC (RDO)
  • Olap
  • OLE DB (ADO)
  • Various other data sources

A report in MineMarket can be designed to populate its data tables by using the following data source types:

  • SQL query
  • External DLL
  • Script

Generally, if a SQL query is used to populate the report, the Crystal Reports template is set up for an OLE DB (ADO) database connection. If an external DLL or script is used to populate the report, the Crystal Reports template is set up for an ADO.NET (XML) database connection.