I use BI for Visual studio which is free (I guess) from MS ,feel better and easy compared to others. All reports on my blog are with this tool.it also give you the flexibility ,pivot tables and to publish the reports to specific folder on Configmgr report server Eswar Koneti www.eskonr.com
From: ga...@enhansoft.com To: mssms@lists.myitforum.com Subject: RE: [mssms] Feedback Request: Developing ConfigMgr 2012 Reports Date: Thu, 31 Oct 2013 10:07:54 -0400 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: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Trevor Sullivan Sent: Thursday, October 31, 2013 9:48 AM To: mssms@lists.myitforum.com 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