SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Report Builder or Reporting Services?


Report Builder or Reporting Services?

Author
Message
AndyOwl
AndyOwl
SSC Veteran
SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)

Group: General Forum Members
Points: 212 Visits: 182
Comments posted to this topic are about the item Report Builder or Reporting Services?

Andy is a director of Wise Owl, a UK company providing training courses (and occasional consultancy) in SQL, Reporting Services, Integration Services and Analysis Services, as well as in many other Microsoft software applications. You can see more about Wise Owl's SQL Server training courses here.
Allan Gartland
Allan Gartland
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 50
Hi Andy
Not a bad summarisation of the differences between the two apps. I think most developers would have to opt for Reporting Services but in our business, end users (interested in reporting) outnumber developers by 20:1. Only one of them is up to speed with Visual Studio and she came from a developer background. My vote is for Report Builder for the vast majority of the business... and to get them off my back creating routine reports ;-)
Allan Gartland
davoscollective
davoscollective
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2531 Visits: 1008
Thanks this is a useful differentiation and would have helped me a few years back Smile

I'm sure you know these things but it might help someone new reading this:

The visual studio environment is introduced as BIDS, and then refered to as SSRS in the rest of the article. The term SSRS really encompasses the whole product including the Reporting Services instance you would install as part of SQL Server, the Report Manager website, the ReportServer and ReportServerTemp databases.

When you install BIDS as an extra from the SQL Server installation disk, you don't get the standard Visual Studio .NET language projects. This is important because BIDS doesn't require separate licensing. You've already paid for the SQL Server licenses so the BIDS tool is a free extra with no installation limitations, likewise the Report Builder tool that you download from the report manager website.

If you install Visual Studio from Visual Studio disks, you don't get the Business Intelligence templates and need to install BIDS from the SQL Server disk. Various versions of Visual Studio will happily co-exist on the same machine.
tom.wauters
tom.wauters
SSC Veteran
SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)

Group: General Forum Members
Points: 204 Visits: 168
We prefer SSRS, because we use some versioning system.
When someone changes an existing report with Report Builder, you aren't able to retrieve the previous version (unless they will save their changes to a new report).
When we make changes through SSRS, thanks to our versioning system, we can always go back to the previous version if we want.

I think this is an important difference for a lot of people, certainly for us Smile !
scott.kent-collins
scott.kent-collins
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 44
A quick reply on your "Strange Bugs"

"2. When assigning a parameter for a subreport, SSRS has no dropdown - you have to type the parameter in. When you consider that the parameter name is case-sensitive, this increases the scope for error for no obvious reason."

My experiences have shown that you can get the subreport parameters as a dropdown, but you have only have 1 chance to do so... and that is when you 1st assign the add the subreport:

1 - add a subreport item to your report.
2 - in the item properties assign a subreport (from your dropdown box).
3 - immediately add the 1st parameter which should give you a dropdown list of the subreport parameters to chose from.
4 - go through and add all the subreport parameters and using the dropdown before exiting out of the properties.

* once you exit out of the subreport item properties and re-enter you can no longer add and use the dropdown option.
Jon Baylis
Jon Baylis
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 9
Great article, bar the proof-reading of the spelling mistakes Smile
lee.emmerson
lee.emmerson
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 183
Another thing missing from Report Builder is the ability to work on several reports at the same time as a project (as opposed to individual reports) and the ability to use source control.
peter.row
peter.row
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1343 Visits: 460
When you use SSRS (the product not BIDS bad naming in the article) in a web app that you sell as a product then it has to be Report Builder since you can't distribute BIDS nor is it a click once install.
snoeren_t
snoeren_t
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 26
My experience is that ReportBuilder is already too complex for the majority of end-users. You really need people who can understand data, relationships and can write a (basic) query (SQL, not MDX because this is certainly not for end-users). An analyst with some technical knowledge (often also the company's excel guru) could work with the tool but usually there are not many around. I think they are also the only people who can qualify for any 'self service bi' tool to be honest.
abcfantasy
abcfantasy
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 38
Good article. I have two opinions to share though:

1. I do not like that the development environment within BIDS was referred to as SSRS. Reporting Services is the whole package or module of MS SQL Server. The interface in BIDS should better be referred to as the Report Designer.

2. Microsoft did intend the Report Builder towards more business users rather than technical people. However, based on my experience, they did not accomplish it very well. Report Builder is only very easy if you want to simply and directly use fields from a database to build a very simple report. However, business needs often extend beyond that, and soon complications quickly arise with the need for special sorting, groupings (anyone experienced trying to sort a report with multiple groups?), calculated fields, parameters, linked reports and expressions.

We attempted to migrate from excel reporting to Reporting Services, and only a handful of technically-minded people managed to catch on with Report Builder 3.0.

The interface is also a little weird, and requires time and constant use in order to get used to it without forgetting - something which business users cannot afford much.

As a report developer however, I am quite happy with being able to develop professional-looking reports with Reporting Services.

With regards,

Andrew.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search