Running a report on multiple companies

Steps to produce a report that pulls information from more than one company in Crystal Reports for Sage

To include all the companies in any one Sage Fixed Assets database on a Crystal Report and to exclude negative (deleted) companies:

In Sage Fixed Assets:

1. Go to: Reports, Reporting, select Create New Report. Enter the Report Title, enter a File Name for the report, and click Create Report. SAP Crystal Reports for Sage will open to the Preview tab. It will only include the System Number and Extension of all assets in the open company.
2. In the Crystal Reports: Go to, Reports, Select Expert, Record, which will open the Select Expert dialog.
3. On the SFA_Company_Information.Company Name tab: Select is equal to or greater than from the dropdown list. Enter 0 (Zero), click OK and click Refresh Data when prompted. This produces a report showing all the companies in the database with no other formatting.
   Alternatively: To avoid issues with special character in the Company Names field in the database, in the Select Expert: Delete the SFA_Company_Information.Company Name tab: click New, in the Choose Field window under WINFASRW: select Company Information, highlight Company Number, click OK, on the SFA_Company_Information.Company Number: select is greater than from the dropdown list. Enter 0 (Zero), click OK and click Refresh Data when prompted.

To get only a list of only the Company Names:

1. On the Design Tab: Right Click Details line, select Hide or Suppress.
2. Go to: Insert, Group, select SFA_Company_Information.Company Name, and click OK.
3. On the Preview tab: There will be a list of all the companies in the database.

Here you’ll have a starting point for consolidating reporting.