Informix Error -8127

-8127 You cannot use more than one REPORT TO statement in a report

The entire report is directed to one destination, which is chosen with the REPORT TO statement in the OUTPUT section. The report cannot be divided between multiple destinations, so remove all REPORT TO statements after the first. If you want to produce separate report files for different sets of data, perform one of the following steps:

* Write a separate report for each set of data (the specifications should differ only in their SELECT statements).

* Produce a full report, but with sets of data on separate pages, and use operating-system utilities and tools to separate the files afterward.

* Use parameter variables in the SELECT statements so that you can choose a subset of data dynamically, when you run the report, and use REPORT TO PRINT so that you can set the DBPRINT variable to control the output destination before you start the report.