I prefer BIDS as well... typically, I'll create a separate folder on the root of the report server called
Custom Reports In that go, the custom DSNs and custom reports. This folder I secure with AD groups and native RS security. Depending on how granular you want to get, you can add additional folders and security based on access requirements. Screenshots... may have to do this for a future blog ;) From: [email protected] [mailto:[email protected]] On Behalf Of Garth Jones Sent: Thursday, October 31, 2013 8:08 AM To: [email protected] Subject: RE: [mssms] Feedback Request: Developing ConfigMgr 2012 Reports I use SSMS to create the queries and then BIDS. RB is not all that useful / difficult for items like drill through, manage lots of RDL, etc... It all depends on the client needs but security group are commonly used. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Trevor Sullivan Sent: Thursday, October 31, 2013 9:48 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] Feedback Request: Developing ConfigMgr 2012 Reports Hey folks, I was just hoping to gather some general feedback about how people are developing and publishing ConfigMgr 2012 reports. Now that we no longer have classic ASP reports, how are you writing reports? Are you using SQL Server Management Studio (SSMS), Report Builder, or Business Intelligence Development Studio (BIDS)? What tools have you found easy (or hard) to use, and what is your workflow for creating reports, and publishing them out to business end-users? Do you create Active Directory security groups to restrict business users to specific SQL Server Reporting Services (SSRS) folders? How do you organize your folders? Any additional feedback you can provide would be helpful, including screenshots. Cheers, Trevor Sullivan
