Shulou(Shulou.com)05/31 Report--

This article mainly introduces "what are the measures for SQLServer2008 to publish the report". In the daily operation, I believe many people have doubts about the measures for publishing the report by SQLServer2008. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts about "what are the measures for SQLServer2008 to publish the report?" Next, please follow the editor to study!

1.ReportBuilder announcement

Log in to ReprotsManager and cross the ReportBuilder to publish your report.

Open MicorsoftSQLServerReportBuilder and click 08 icon-open--- to find the local report RDL file, the process is a bit slow, let the same choice 08 icon-PublishReoprtParts

And then two more choices.

1.PublishAllreprotpartswithdefaultsettings

2.Reviewandmodifyreportpartsbeforepublishing

In case we have to amend some statements published in the directory can choose 2, otherwise the default option 1 starts to publish.

Click publish to announce and click CLOSE.

The announcement is over.

Advantages do not need to choose between DATASOURCE and DATASET, eliminating the tedious.

two。 Upload the report manually

Similarly, log in to ReportsManager through Uploadfile and put the RDSRDLRSD file in the corresponding folder you set. The uploaded report is on the report server, but it does not work. The reason is that the uploaded file is self-reliant and has no contact. We must connect the report and the data source and click on the uploaded report. Drop-down menu-manage---datasources-Ashareddatasource---Browse- finds the datasources file you uploaded.

Pros: no tools are needed.

What are the measures taken by SQLServer2008 to publish the report?

3. Travel through BIDS to announce

Wait till we use BIDS to edit the report and use it to publish the most appropriate (in case your BIDS can connect to the SSRS server) set schedule properties right-click the report project, and then click Properties. In the item target property pages dialog box, select the collocation you want to edit from the collocation list.

The common collocations are DebugLocal, Debug and Release. In the OutputPath text box, type the path in your local file system to store the report definition used during the review, scheduling, and preview of report generation. This path must be different from the project target path you use, and it is a relative path (that is, a subfolder under the project path).

ErrorLevel can be used to add or decrease the sensitivity of generation. For example, when a report with a map is generated during scheduling to the SQLServer2008 report server, the error is revealed by default, and the report generation process fails. In case you decline the ErrorLevel and remove the map from the report, the warning is revealed and the report generation process continues.

In the StartItem list, select the report to reveal in the preview window or the explorer window when you run the report project.

In the OverwriteDataSources list, choose True to mask the shared data source on the server each time the shared data source is published, or select False to retain the data source on the server.

In the TargetServerVersion list, choose the SQLServer2008 or SQLServer2008R2 version of ReportingServices, and you may choose to "detect the version" to actively determine the version installed on the server identified by the TargetServerURL attribute. The default is SQLServer2008R2.

Using TargetServerVersion, you can customize the generated reports, which are located in the path specified in OutputPath and correspond to the report server version specified in TargetServerURL.

In the TargetDataSourceFolder text box, type the folder on the report server where the advertised shared data source hui.huikao.org is placed. The default value for TargetDataSourceFolder is data Source. In case this value is left blank, the data source is advertised to the location specified in the TargetReportFolder.

In the TargetReportFolder text box, type the folder on the report server where you want to place the published report. The default value for TargetReportFolder is the report item target name.

Then solutionexplorer is selected and your report PROJECT is right-Deploy expects the announcement process to come to an end.

At this point, the study on "what are the measures for SQLServer2008 to publish the report" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.