SSRS and Project Subfolders

SSRS and Project Subfolders

If you’re like me, you like to keep your reports well organized. This gets harder when you start to deal with hundreds of reports across multiple departments. In my case, our Marketing team is split into two forms: Acquisition and In-Life. I want to keep Acquisition Marketing specific reporting within an Acquisition folder, complete with permissions configured as needed. In-Life belongs within In Life and Marketing reports that apply to both can sit in the Marketing root folder.

Marketing Folders

The problem is, you cannot create folders within Visual Studio BIDS projects. You can though, create a new Project and point to the folder on the Report Server.

The trick is to ensure that you enter the required folder names within the Target Report Folder property.

  1. Right click your project from the Solution Explorer and click Properties.
  2. Ensure your TargetServerURL is set to http://<yourservername>/reportserver
  3. Set your TargetReportFolder, in the form <projectname>/<subfoldername>
  4. In my case the TargetReportFolder will be:ย Marketing/Acquisition

Marketing Project

It is important to note that the folder needs to be configured withinย TargetReportFolder, you cannot configureย TargetServerURLย anything beyond the location of the reportserver.

ie. You can’t setย TargetServerURL as http://<yourservername>/reportserver/Marketing

Subfolders within BIDS/Visual Studio would be preferable, but this will suffice.

Hope this helps.

Mike250

Australian. Sport. Passionate Cricket Fan. Go Pro. Abseiling. Snorkeling. Travel. Golf R. SQL Server Developer. Three sons. One daughter. Last Trip: New York.

Related Posts
2 Comments
    • No need to ask me twice ๐Ÿ™‚

      Reply
Leave a comment

Your email address will not be published. Required fields are marked *