Current location - Training Enrollment Network - Education and training - Excel is badly needed as a template for daily, monthly and annual sales reports?
Excel is badly needed as a template for daily, monthly and annual sales reports?
If you take the source data directly from the database and edit it into daily report and monthly report, you can find the report tool, which can save a lot of time and energy.

The operation steps are as follows

In the new data source, set directly.

2. Add a data set

You don't have to write stored procedures for datasets. You can directly use the visual data editor to drag and drop several original tables to generate natural links.

3. When using data control, automatic data grouping, summary analysis, it saves the complicated stored procedures of programming.