Set up report

From Crystal Manager for Sage CRM

If you have just uploaded a new report you will be in the "Report Detail" screen.

Set the details as you need and click "Save"

  • Description: Allows you set a report description
  • Entity: From the drop down select the entity context that the report would run in
  • Category: Select from the drop down
  • Owner: The report owner
  • Ignore Security: Option to ignore user/team security on the report
  • Visibility: Option to hide this report from the main reports area

Report Parameters

Any parameters in the report are displayed in the "Parameters" section. To map entity fields to the parameters you click "Change" (you must have saved the details first) and then from the drop down select the field and click "Save"

Note that the fields in the drop down depend on the "Entity" selected in the Report Details. Current user fields are also available and this allows the current user context to be used as well as the entity fields/context.



Report connections

When you upload and view a report you will see the databases and table that the reports use

The database name listed here must match the database in the Config area

Each database listed must be configured in the Config tab. You will see if the report can connect or not.