Allow Sub Folders in SSRS Projects - by mrdenny

Status : 

 


279
0
Sign in
to vote
ID 487106 Comments
Status Active Workarounds
Type Suggestion Repros 25
Opened 8/31/2009 1:14:23 PM
Access Restriction Public

Description

I think that it would be great if we could create sub folders under the Reports folder of a SSRS project in BIDS so that if we needed to create folders for our reports on the Report Server we wouldn't have to keep them in separate projects with separate data sources.

I know that we can have multiple projects in a single solution, but this is just a work around.  I've got a dozen projects in a single solution in BIDS and when I make changes to reports in different folders that are related but for business reasons are in different folders I have to find them in each project.  It would be much simpler and quicker if they were in a single project but in different folders.

This would also allow for BIDS to allow you to link to a report in a sub folder for drill down.
Sign in to post a comment.
Posted by sbogar on 3/16/2017 at 11:52 AM
Why do I get the feeling SSRS is becoming the 'old and busted' compared to the 'new hotness' that is Power BI...please do not abandon SSRS Microsoft it is the only product keeping me on the ship!
Posted by markgoldin on 3/4/2017 at 1:10 PM
What? Another fuckup?
Posted by dww142 on 11/4/2016 at 10:18 AM
SQL Server Data Tools is now releasing new versions monthly, I've started linking this feedback request on their blog: https://blogs.msdn.microsoft.com/ssdt/ for each months release post. I suggest others do the same and bring some attention to his.
Posted by Dave Radcliffe on 10/26/2016 at 4:44 AM
I cannot believe that Visual Studio won't allow this when working on a Reports project.... It allows (nay, encourages - see ASP.MVC) sub-folders for other project types.

Please enable this NOW!!!!
Posted by dww142 on 10/21/2016 at 9:51 AM
Created in 2009, with NO response from Microsoft in 7 years... this is ridiculous and embarrassing - 2008R2, 2012, 2014, 2016 - have all been released since this item was created with no attempt to address this issue. I am recommending SSRS to a client as a replacement to another BI tool, but this limitation is going to be a sticking point to their development staff; stupid - maybe, but it will cost MS and the client will look elsewhere.
Posted by yes please on 10/13/2016 at 9:30 PM
Wow, this seems like rudimentary functionality. Why is this missing???!!?!?
Posted by sarah_hl on 9/8/2016 at 1:38 AM
Come on Microsoft - make SSRS capable of easily managing Enterprise-level report management, as it currently stands it's a joke and just not up to the job
Posted by Stevie6410 on 8/18/2016 at 8:28 AM
This is critical to enterprise SSRS workflow and organisation.
Posted by Raphael Nash on 7/12/2016 at 7:33 AM
I need the ability to add subfolders under reports and have those map to folders in SSRS.
Posted by ptrubs on 1/11/2016 at 4:47 PM
that was a statement, not a question....
Posted by ptrubs on 1/11/2016 at 4:46 PM
Still no joy with the preview for SSDT for SQL2016 and VisualStudio 2015?
Posted by TickboxPhil on 10/8/2015 at 7:47 AM
This is a serious limitation for real non-trivial deployment, it makes SSRS a laughing stock - and Microsoft too, seeing it doesn't clarify this issue over almost a DECADE! Customers finding this out after spending over £5K on a minimum 4 core Standard license are not happy.

Either fix it, or publish a simple Blog or FAQ, anything official, which states this limitation is only due on the shell edition of VS, not full (in which case, fair enough, just stop wasting your key resellers/devs/promoters time). I can't try it on our current version VS2015 Pro because SSDT doesn't install on it... grrr... (another badly documented time-waster)! Sort it out or lose customers, as others here have noted.
Posted by Imbastuff on 9/7/2015 at 10:36 PM
Enterprise capabilities and manageability require a well-structured solution where maintenance tasks is not hampered by basic missing features.

Currently SSRS lacks these basic features, and from a maintenance perspective is more targeted at a small company having 5-10 reports only.

Subfolders is a MUST in the next release. I have +5000 user customers that currently refuse to use SSRS due to its cumbersome approach. Sure there are workarounds but when you reach enterprise sized solutoins, these workarounds just emphasize the issue.
Posted by TheMaxter on 9/3/2015 at 8:17 AM
Without sub-folders for reports how can Microsoft expect to be taken seriously in the BI / Reporting space ?
Posted by AndySugs on 6/29/2015 at 3:45 PM
What is wrong with Microsoft? It's obviously an issue. Everyone knows it's an issue. The solution is not that difficult. Ergo it just needs Microsoft to pull their finger out. Come on Microsoft! Why are you making life so difficult for everyone when it's such a straightforward request?!!
Posted by Tom Loomis on 3/18/2015 at 8:52 AM
Any updates? VS proper deals with this no problem. Why not just expose the root functionality to the VS variants like BIDS and SSDT. It doesn't have to be this complex.
Posted by Peter Wood on 5/5/2014 at 8:11 AM
Microsoft: why not open source the SSDT VS addin (you can still work on it, though you don't appear to have made many changes recently) so that people can look at fixing these problems?
Posted by Peter Wood on 5/5/2014 at 7:59 AM
This limitation cripples BIDS/SSDT. We have 500 reports and associated stored procedures which we would like to convert to SSRS, but can't manage them without a folder structure. If one edits the project file, Visual Studio seems to be OK with a report in another folder, so this appears just to be a limitation of the SSDT UI. Doesn't make sense, considering how good VS is with C# projects. Please sort out!
Posted by Pat B on 4/18/2014 at 12:48 PM
Trying to embrace SSRS over Crystal Enterprise (an old version of Crystal) and having a lot of trouble understand why a Reporting Project cannot organize reports into sub-folders. If you have hundreds of reports for different departments, it sure would be nice to be able to organize the reports into folders. The work-around of creating multiple projects (one for each folder) in a single solution is problematic in that it makes it very difficult, if not impossible, to share data sources and data sets.

Come on Microsoft, address this issue! Thank you.
Posted by Dave Lucre on 12/3/2013 at 6:56 PM
Microsoft, please seriously consider this for the 2014 CTP if you have not already. Sub Folders which map to folders on the Reporting Server would make our lives MUCH easier.
Posted by R.Kuhn on 12/2/2013 at 11:34 AM
Still no answer, Microsoft?

Why do you maintain this site, if you chose to ignore the community anyway?

Its not even hard to implement ...
Posted by SAinCA on 12/5/2012 at 3:59 PM
SSRS has been begging for this since SQL2005! This is a REAL NEED.

Having to create separate deployment configurations per project just to handle subfolders on the target is ridiculous.

"Globally Shared Data Sources AND Datasets" - absolute NEED. I have 6 projects with the same name data source that only exists once on the server - thankfully. And being unable to properly use what should by rights be shared resources IN A SOLUTION is very restrictive and leads to unnecessary duplication, thereby maintenance.

3 years, 3 months, 6 days and counting........

It would be very opportune if Microsoft were to overhaul the entire folder+configuration-manager scheme. It's a royal pain to add servers for deployment and clone in Configuration Manager. The number of hours I've spent hunting for the right place to clone and modify without damaging anything is painful to remember and BOL is just plain deficient in this area.
Posted by Realsirocco on 9/13/2012 at 2:29 AM
I wouldn't minds but visual studio natively has the facility to create your own folder structure, its been disabled in BIDS!

I ended up having to write an app to deploy my reports using a hidden parameter as the directory structure. not elegant but effective.
Posted by CRMScholar on 8/6/2012 at 3:04 AM
47 votes - and no answer from microsoft in 3 years.

I would like either this - OR to have shared data sources and shared datasets at the solution level as well.

Basically i need a way to have different deployment options (where to deploy to etc) but have shared data sets and sources across multiple projects.
Posted by Daniel Castenholz on 2/2/2012 at 2:12 PM
Additionally, having a hidden folder for sub reports would be a BIG improvement. I can do it in Report Builder, but not in Visual Studio. That is BACKWARDS. Give the developer more power than the end user, not LESS! The current limitations are very counter productive.