X-Received: by 10.42.240.19 with SMTP id ky19mr7006703icb.4.1392593162930; Sun, 16 Feb 2014 15:26:02 -0800 (PST) X-Received: by 10.182.213.7 with SMTP id no7mr26013obc.19.1392593162822; Sun, 16 Feb 2014 15:26:02 -0800 (PST) Path: csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!news.glorb.com!c10no25675185igq.0!news-out.google.com!h8ni12igy.0!nntp.google.com!uq10no24151918igb.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.ms-sqlserver Date: Sun, 16 Feb 2014 15:26:02 -0800 (PST) Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=92.40.198.162; posting-account=dELd-gkAAABehNzDMBP4sfQElk2tFztP NNTP-Posting-Host: 92.40.198.162 User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <64e503ac-3deb-4364-b2bc-9899dfe6e2a3@googlegroups.com> Subject: Suitability of SQL Server Reporting Services 2012? From: rja.carnegie@gmail.com Injection-Date: Sun, 16 Feb 2014 23:26:02 +0000 Content-Type: text/plain; charset=ISO-8859-1 Xref: csiph.com comp.databases.ms-sqlserver:1688 I think I've been asked a silly question. Here it is. Currently we use SAP Business Objects XI Version 2 and an Apache web server to generate reports from data on SQL Server 2005, standard edition. It's a bit wobbly. We've gone on to obtain Version 3 and Version 4, which we can't get to work. We're supposed to be trying 4.1 soon. I've been asked to look at whether we can do it all with SQL Server 2012 and SQL Server Reporting Services, instead. Currently most of the reports are on any of a set of databases for different regions. Business Objects provides a set of "universes" from which users can run our reports on demand or scheduled, viewed in a web browser, exported, or in e-mail, or design their own. We also limit a set of one or more "costcentres" whose data any given user gets to see. I've read that the latest version of SSRS is closely tied to Microsoft SharePoint, which I think no one here has seen. And I'm a poor learner nowadays. We don't have a lot of money to spend. Not any more, anyway. Is converting to SSRS feasible for us, or is it an awful lot of work, or just not worth considering?