Visual Studio

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.

Share on Google Plus

Mike250

Australian living. Sport. Passionate Cricket Fan. Go Pro. Abseiling. Snorkeling. Travel. Golf GTI. SQL Server Developer. Three sons. One daughter.

2 Comments

Leave a comment

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