Allow Sub Folders in SSRS Projects
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.
Upvotes: 309<=-=Feb 2 2012 2:12PM=-=>
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.<=-=Aug 6 2012 3:04AM=-=>
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.<=-=Sep 13 2012 2:29AM=-=>
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.<=-=Dec 5 2012 3:59PM=-=>
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.<=-=Dec 2 2013 11:34AM=-=>
Still no answer, Microsoft?
Why do you maintain this site, if you chose to ignore the community anyway?
Its not even hard to implement …<=-=Dec 3 2013 6:56PM=-=>
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.<=-=Apr 18 2014 12:48PM=-=>
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.<=-=May 5 2014 7:59AM=-=>
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!<=-=May 5 2014 8:11AM=-=>
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?<=-=Mar 18 2015 8:52AM=-=>
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.<=-=Jun 29 2015 3:45PM=-=>
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?!!<=-=Sep 3 2015 8:17AM=-=>
Without sub-folders for reports how can Microsoft expect to be taken seriously in the BI / Reporting space ?<=-=Sep 7 2015 10:36PM=-=>
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.<=-=Oct 8 2015 7:47AM=-=>
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.<=-=Jan 11 2016 4:46PM=-=>
Still no joy with the preview for SSDT for SQL2016 and VisualStudio 2015?<=-=Jan 11 2016 4:47PM=-=>
that was a statement, not a question….<=-=Jul 12 2016 7:33AM=-=>
I need the ability to add subfolders under reports and have those map to folders in SSRS.<=-=Aug 18 2016 8:28AM=-=>
This is critical to enterprise SSRS workflow and organisation.<=-=Sep 8 2016 1:38AM=-=>
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<=-=Oct 13 2016 9:30PM=-=>
Wow, this seems like rudimentary functionality. Why is this missing???!!?!?<=-=Oct 21 2016 9:51AM=-=>
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.<=-=Oct 26 2016 4:44AM=-=>
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!!!!<=-=Nov 4 2016 10:18AM=-=>
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.<=-=Mar 4 2017 1:10PM=-=>
What? Another fuckup?<=-=Mar 16 2017 11:52AM=-=>
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!<=-=Apr 6 2017 10:31AM=-=>
Hi sbogar – We have heard the feedback. I cannot guarantee we will do it soon, but we do have it as an important customer pleaser and it is something I would really like to do for you and the rest of our loyal customers. I am going to make a post on the RS forum for feature behavior feedback.