Sales channel reports are applied widely in enterprise. There are common problems in generating these reports, such as hard in data acquisition, single on report format, data redundancy, low efficiency on data utilization and so on. To tackle these problems, a sales channel reports system are designed and implemented with IBM Cognos TM1 on the background of one real project. Design a whole data model via different data acquisition templates and combining with several kinds of data sources and data visualization are mainly researched, flexible report format and how to generate reports dynamically according to different conditions are provided. Verified by actual data of enterprise, the system is running steadily, reduces manpower and resources in the process of reports production, fully taps the potential of information of data itself, improves the utilization of data greatly.