SQL Server Reporting Service (SSRS) Fifth SSRS Deployment Summary

The previous time completed the first batch of SSRS report development, originally thought that the merit has been gaocheng, the result did not think in the whole release and deployment process still encountered a lot of problems, these problems are listed, I hope to be able to be inspired later!

1. About the publication of data sources and datasets (reports automatically refer to corresponding data sources and datasets)

In the process of using SSRS development, we inevitably use shared data sources and shared datasets for ease of use. However, in the convenient development of the report at the same time, sometimes after the report may not find the corresponding data source, we need to manually select the data source and the data set storage method. After investigation, I found that for the data source and the data set of the publishing address, we can make self-tuning, as shown in:

2. About the use of shared data sets

After creating the shared dataset A, for some reason, I had the wrong idea to create another dataset B to use that shared dataset A, and then use DataSet B to populate the drop-down list. Now think about what you were thinking when you could use data set a directly.

3. About access to data sources

No matter how the development process, after the report is published, the best result is to configure the following crddential or no configuration to complete the release of the report and the user access to the correct;

　　

SQL Server Reporting Service (SSRS) Fifth SSRS Deployment Summary