x

Crystal Reports vs Business Objects

What is the real difference? I know Business Objects produces the product, but I hear the term Business Objects pretty often compared to Crystal Reports. I'm wondering if one could be a server side installation for reporting, similar to SSRS? Also, has anyone here used these products in any big projects?
more ▼

asked May 04, 2011 at 04:58 PM in Default

xypher gravatar image

xypher
416 6 7 9

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
My 2 cents is that Business Objects is the back end on demand system that would compare to SSRS. In SSRS we can build reports that end users can go to a URL and run either by keying in values for the search criteria or just running the report. Reports can also be scheduled to run at a certain time, dropped into Sharepoint, emailed, printed, etc. Business Objects is much the same way, users hit an interface key in some values and run the report, reports can also be ran at specified times, exported etc. Crystal Reports I want to say was acquired by the Business Objects folks and is more of a client side application for creating and running reports. Many third party applications also use features of Crystal Reports within their application.
more ▼

answered May 05, 2011 at 04:07 AM

Tim gravatar image

Tim
36.4k 36 41 139

it is very blurry! But BO is much more than just reports - it is the whole data model, universe definition etc.
May 05, 2011 at 04:17 AM Kev Riley ♦♦
Ah yes, how could I forget about BO having to create universes for all the data served up for the reports. What a bear. We use Business Object at the shop I work at and just this past week I installed SSRS to take some of the burden off our DBA group for having to generate so many reports on demand. Our BI group complains they don't have the time or resources to create so many adhoc reports. I wish I knew more about the Business Objects product because it is rather powerful and well used, but I don't get to play much outside of my DBA sandbox.
May 05, 2011 at 04:58 AM Tim
(comments are locked)
10|1200 characters needed characters left

Business Objects has it's origins in OLAP, so I would take it that BO is often referred to as the whole OLAP/BI offering, whereas Crystal is 'just' the reporting engine.

The SQL equivalent would be (ish) SSAS = BO and SSRS = Crystal
more ▼

answered May 05, 2011 at 02:02 AM

Kev Riley gravatar image

Kev Riley ♦♦
53k 47 49 76

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x8
x2

asked: May 04, 2011 at 04:58 PM

Seen: 1933 times

Last Updated: May 04, 2011 at 04:58 PM