As described in Part 1 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)
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:
The Server Properties window is displayed with a navigation list on the left consisting of the following:
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.
The Advanced page is displayed as shown:
The description of everything that a user with the assignment My Reports role can do is as follows:
May publish reports and linked reports, manage folders, reports, and resources in a users My Reports folder.
Report Builder 2.0 is displayed.
The Open Report dialogue appears as shown. When the report Server is offline, the default location is My Documents, like Microsoft products Excel and MS Access.
The Report server that is active should get displayed here as shown:
All the folders and files on the server become accessible as shown:
Verify that a My Reports folder is created for the user (current user).
There could be slight differences in the look of the interface depending on whether you are using the RTM or the final version of SQL Server 2008 Enterprise edition.
I remember deciding to pursue my first IT certification, the CompTIA A+. I had signed…
Key takeaways The transformer architecture has proved to be revolutionary in outperforming the classical RNN…
Once we learn how to deploy an Ubuntu server, how to manage users, and how…
Key-takeaways: Clean code isn’t just a nice thing to have or a luxury in software projects; it's a necessity. If we…
While developing a web application, or setting dynamic pages and meta tags we need to deal with…
Software architecture is one of the most discussed topics in the software industry today, and…