Make shipping statistics report

1. Problem description

The statistical table of delivery is one of the commonly used reports in enterprises, which may include the number of this week, the number of this month, the number of this year, the number of last year, year-on-year increase or decrease, the number of plans, and so on, and some of them are even linked to the salaries of salesmen, so it is necessary to calculate the reward and punishment wages directly.

If you were asked to calculate the above data, what method would you use? How long does it take? And this report is periodic, round and round, never ending. I dare say that most people will use EXCEL tables to do, the specific speed depends on your EXCEL application level, but want to query immediately, I think it is impossible, even to do a simple one will take an hour. Is there a way to get started without programming, especially for practical workers who don't know how to program but have a lot of work experience? Of course, let me introduce a method to you. As long as you know a little bit about SQL, you can make complex WEB reports.

2. Production method

2.1 due to the large amount of data, using the method of intermediate table, using the scheduled task of the database to collect data to the intermediate table every night, we must give priority to the performance of the report, few users can bear to wait for a long time, they will be mad at you, but if the amount of data is small, this step can be skipped.

2.2 FR supports multiple data sources, which have nothing to do with the document data into a separate dataset:

2.3 bind data and make templates

3. Effect display