A data collecting and processing method based on a report tool comprises the following steps: S1, constructing a database; S2, collecting data, and storing actively and passively collected data in a database to form source data, wherein the data collection process comprises active collection and passive collection, the active collection is ETL tool collection, and the passive collection is carriedout through data reporting collection; S3, generating a report: creating a new report, inputting a report rule, and importing the source data in the database into the report according to the report rule to form the report; and S4, reading report. Two groups of data collection systems, namely an active collection system and a passive collection system, are arranged, so data distributed at all levels can be centralized into the database, the problem of information islands at all levels originally is solved, the integration degree and the exchange speed of information are improved, and the difficulty of information exchange at all levels is reduced; and meanwhile, a report engine is arranged, so that custom design of table styles and dynamic generation of table contents are realized.