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]] On Behalf Of Trevor Sullivan Sent: Thursday, October 31, 2013 9:48 AM To: [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
