P E A R L   E C H 0   U S E R   G U I D E  

SQL Server 

You can set the Pearl Echo Report Manager to report against data that has 

been logged to a Microsoft SQL Server.  Under the Advanced button in the 

Reports tab, enter the SQL Server name, database and table where your Pearl 

Echo data resides. 

Running reports on SQL Server allows data processing to be optimized on the 

SQL Server and is not constrained by a 2 GB data limit.  When the SQL Server 

Data Source is selected, all other data sources in the report manager are 

cleared. 

You can specify any database and table that contains Pearl Echo formatted 

data as your data source   including archive databases created by your SQL 

Server DBA. 

File 

You can specify a particular file against which a report will be run.  The file 

you specify must be in Pearl Echo's native xBase file format.  Pearl Echo files 

are created by saving filtered or sorted versions of the Pearl Echo Activity 

Log. 

Saving a Report 

Once a report's optional date range, parameters, group and data sources 

have been defined, the report can be saved for future use by selecting the 

Save as Custom button on the Reports tab.  When saving a custom report, 

you will be prompted for a report title and description, both of which will 

appear on your report when the report is run.  This feature provides you with 

the ability to customize how the report header is displayed in order to fit your 

specific needs.  Once saved, your new report will appear in the Custom 

63