At the very bottom of the Report Builder you will get an indication as to the Report Server you are connected to (present case there is only one running) and its status as shown in the following screenshot. You can also change from design to run (preview) by clicking on the respective icons in this figure. You can also enlarge or reduce the size of the report both in design and in preview using the zoom slide.

Hands-on exercise 6.1: Enabling and reviewing My Reports

As described previously the My Reports folder needs to be enabled in order to use the folder or display it in the Open Report dialogue. The RC0 version had a documentation bug which has been rectified ("https://connect.microsoft.com/ SQLServer/feedback/ViewFeedback.aspx?FeedbackID=366413).

Getting ready

In order to enable the My Reports folder you need to carry out a few tasks. This will require authentication and working with the SQL Server Management Studio. These tasks are listed here:

1. Make sure the Report Server has started.
2. Make sure you have adequate permissions to access the Servers.
3. Open the Microsoft SQL Server Management Studio as described previously.
4. Connect to the Reporting Services after making sure you have started the Reporting Services.
5. Right-click the Report Server node.
   The Server Properties window is displayed with a navigation list on the left consisting of the following:
   • General
   • Execution
   • History
   • Logging
   • Security
   • Advanced

   In the General page the name, version, edition, authentication mode, and URL of Reporting Service is displayed. Download of an ActiveX Client Print control is enabled by default. In order to work with Report Builder effectively and provide a My Reports folder for each user, you need to place a check mark for the check box Enable a My Reports folder for each user. The My Reports feature has been turned on as shown in the next screenshot.
   .
   In the Execution page there is choice for report timeout execution, with the default set such that the report execution expires after 1800 seconds.
   .
   In the History page there is choice between keeping an unlimited number of snapshots in the report history (default) or to limit the copies allowing you to specify how many to be kept.
   .
   In the Logging page, report execution logging is enabled and the log entries older than 60 days are removed by default. This can be changed if desired.
   .
   In the Security page, both Windows integrated security for report data sources and ad hoc report executions are enabled by default.
   .
   The Advanced page shows several more items including the ones described thus far as shown in the next figure.
   .

   
   
   
   
6. In the General page enable the My Reports feature by placing a check mark.
7. Click on the Advanced list item in the left.
   The Advanced page is displayed as shown:
   

    

   
   

   Next Page: Report Builder 2.0 - Server Status and Tools - Page 2