ASP. net2.0 reportingservices, the receiver of the report soul (1) [original month]

This article will give a brief introduction. For more information about reportingservices, see the following.

1. open bids. This is a report development tool.

2. Create a project

3. Select "Business Intelligence Project" and select "Report Server Project Wizard"

4. In the new window "Report Wizard", select next

5. Enter the data source selection window and click "edit"

6. Click "edit" to bring up the window for selecting data sources and data tables. Are you familiar with this window?

7. Click test connection ".

8. Click "OK ". Return to the "Select data source" window. Select "make it a shared data source ".
This data source can be used by other reports.. Click "Next"

9. Go to the "design query" window in the wizard and click "Query Builder"

10. The query generator window is displayed. Click "Universal Query designer" on the far left"

11. Click "Add Table" on the rightmost side"

12. Select the expected table in the pop-up window.

13. Check the fields in the table. The tool automatically generates SQL statements for you. You can also select the sorting type.

14. Click "OK" to go to the "design query" page. We can see that the query string has been generated. In fact, you can write the query string by yourself without entering the complicated wizard interface. Click "Next ".

15. In the "Select Report Type" window, select "table ".

16. Click "details" for all fields to enter the "details" box. Of course, you can "group ".

17. Click "Next" and "Select Table Style ". Select one.

18. "select deployment location"

19. In the last step, summarize the information and click "finish ".

20. Go to the "layout" page of the report design. Note that the first field arrangement is messy. Click "preview" to view the report and the report will be rearranged.

21. Click Preview to view the final report page. Select "Export" to export PDF, Excel, and other formats. Print, page layout function is good.

22. Switch to the layout page again. Click "toolbox" at the bottom left ".

23. There is also a matrix table. You can drag it to the right. Select "chart ". It's a bit tricky.

24. Switch to the dataset window on the left. Place the corresponding fields on the "chart.
Create a 2-dimensional chart first.

:

Make a three-dimensional one. The three dimensions are not the three dimensions of the image appearance. It is a three-dimensional graph data.

:

There are many custom settings for charts. You can right-click "attributes" to set them.

25. Set the report title. Right-click the report to define the style.

26. "generate" and "deploy ". Any errors may occur when the time of the subordinates is long.

27. You can also click "generate" and "deploy" in the right menu. "Run" or "debug" to check the effect on IE.

28. Effect on IE

29. Briefly Talk About report management. After reportingservices is installed, there is a "reports" virtual directory in IIS. Run "home. aspx"

Click Report Project

30. Now, the production of the simplest report is complete. Of course, the reportingservices function is very powerful. Due to time issues, this article can only end here. For more information, see the future.