Learning about Report Manager (SQL)
Description
Cause
Resolution

The Report Manager in the Estimating Management Console is essentially an application program interface (API) that enables you to use Sage Estimating to create estimate reports based on a report design you create in Crystal Reports or Microsoft Access.

When you create an estimate report in Report Manager, you select the Crystal Report design or the Microsoft Access report design that you want to use as the basis for the estimate report. Report Manager then creates a copy of the report design in its custom report database.

When you modify the report, you check out the report design from the custom report database. Report Manager does not use the original report design file again. Instead, Report Manager uses the copy of the report design for all subsequent report design changes.

Before you can create report designs, you must also select one or more estimates from the estimates grid of the Report Manager window to generate report sample data. Report Manager creates tables for the sample data in a separate custom reports database based on one or more representative estimates that you select. You use the tables and the fields contained in this sample database when you set up your report design in Crystal Reports.

Note: An Estimates database can contain many estimates with a mix of features, but you print a report for one estimate at a time. Therefore, you need to set up your report designs to extract data from a single estimate.


[BCB:164:Chat Estimating US:ECB]

Steps to duplicate
Related Solutions

Creating sample data for report designs (SQL)

Adding a report to the Report Manager (SQL)

How to design a simple Estimate report in Crystal 

Supported Custom report views for estimates (data) (SQL)

How do I install Crystal Reports?