New to SSRS 2008

[informer30]

Hi All,

I have been given a task to choose a BI reporting tool from either Business Objects or SSRS. I come from a Business Objects background and want to better understand SSRS.

Please can you advise like in BO there is a universe so one change can impact many reports, is that functionality available in SSRS?

BO has Infoview as its deployment interface how are reports deployed from SSRS?

Also has anyone heard of Strategy Companion Analyzer? Is this owned by Microsoft? Any good?

Many Thanks

 

[xlbo]

SSRS doesn;t use metadata per se so there is no real equivalent of "universe" - this would realistically be replicated in a schema or set of views set up in the database behind

Reports are developed in BIDS or visual studio and deployed to the "report manager" which is an ASP.NET gui for interacting with the reports. the report defintion itself is held in a database on SQL Server

SSRS is "free" if you have SQL Server - BO is expensive. BO has many built in features that are not there by default in SSRS but most if not all can be mimicked through either SQL or ASP.NET development

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[informer30]

xlbo, thanks for your info. Please can you advise what the difference is between SSRS2008 and report builder is BIDS in sql 2008 or 2010?

Also would you know what version of sharepoint is required to deploy SSRS? Is it sharepoint or Sharepoint Enterprise?

Many Thanks

 

[xlbo]

SSRS 2010 is really 2008 R2 and there's very few differences in the dev environment - the main changes are to SQL Server itself not SSRS.


Can't comment on sharepoint as have not used SSRS in sharepoint environment - technically you don't need it to use SSRS at all

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question