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


The Report Builder


The Report Builder

Author
Message
Andy Warren
Andy Warren
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: Moderators
Points: 11463 Visits: 2730
Comments posted to this topic are about the content posted at temp

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Duray AKAR
Duray AKAR
SSC Rookie
SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)

Group: General Forum Members
Points: 33 Visits: 1

Great point!
Totally agree on the developer's "lack of interest" in this tool, and this is understandable.
Why would you spend time on something that you would not use yourself?
Especially when you are LEARNING a million things a day,
and trying to grasp the load of information you are being exposed to during a "developer training"...

But I think as the SQL Reports get used more and more, the "Power User" will get into that.

Not just this particular product, but I run across many things
that I believe eventually will make the "Power User" segment in the IT education industry stronger, and more popular...
More training sessions specifically tailored for the people that are not developers,
but savvy computer users that like to "dig in"...

And I think selling this particular tool as an "Add On", or charging some extra for it might help grabbing some attention...

Good job on pointing that out.


Kent Roberts-241680
Kent Roberts-241680
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 58
I get an "Authentication Error" when I try and run Report Builder on my system. It looks like there is some configuration that needs to take place on the server in order to access it.

http://msdn2.microsoft.com/en-us/library/ms365173.aspx

Maybe the author could add a paragraph about that.
Stephanie J Brown
Stephanie J Brown
SSC Eights!
SSC Eights! (906 reputation)SSC Eights! (906 reputation)SSC Eights! (906 reputation)SSC Eights! (906 reputation)SSC Eights! (906 reputation)SSC Eights! (906 reputation)SSC Eights! (906 reputation)SSC Eights! (906 reputation)

Group: General Forum Members
Points: 906 Visits: 1103
This is exactly what I've been hoping for, since I have a set of users that are constantly asking for ad-hoc reports (in response to external client requests). We are in the process of installing SQL Server 2005, so I'm looking forward to checking out Report Builder. I do wish the article had gone into a little more detali!


Here there be dragons...,

Steph Brown
JSM-257162
JSM-257162
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 9
Stephanie, you might want to check out this article:

Generate Ad-hoc Reports with Microsoft Reporting Services 2005

http://www.devx.com/dbzone/Article/28047#rateThisContentLink


Robert Neal
Robert Neal
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: 54

I have looked at Report Builder and run some demos. The product is easy to use and the report model helps the user. The problem is the user must be connected to SQL Server to use the report.

My goal in using Report Builder was to distribute data to the user with a limited function report writer. For example, the last 12 financial statements for the divison of a company. The user could export to Excel, select a month of data or select a group of accounts. The user would probably install the report on a laptop computer.

Currently, the solution to this problem remains Excel.

Bob Neal




Robert Neal
Andy Warren
Andy Warren
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: Moderators
Points: 11463 Visits: 2730
We'll have more coverage of Report Builder soon I think. As far as connected, absolutely thats the limitation. Not unreasonable I think all in all, but constricting at times. Definitely it makes sense to use Report Builder to pull the data into Excel where they can do more analysis, the big win is that IT doesnt have to pull the data for them.

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
philcart
philcart
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4096 Visits: 1436

The big chore I've come across with Report Builder is translating all the database fields into recognisable form for end users eg: only after a few years working with this database, I've come to recognise the cryptic a-re-dte ( not my choice in naming conventions ) is the Actual Receipt Date field, as opposed to re-en-dte which is the Receipt Entry Date field.

It would also be good to see a few more report templates available. After using the Visual Studio Report Designer to produce some promising reports with Detail, Summary, Matrix and Graph all on one report its a little bit of a come-down to be limited to such basic report templates.



Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface

Australian SQL Server User Groups - My profile
Phills Philosophies
Murrumbeena Cricket Club
Leif Peterson
Leif Peterson
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 16
After spending several evenings working out security issues I finally got the Report Builder working only to discover that my views did not make it from my "view" to my "model". I tried creating a simple report off a base table but got a empty result set. Since the sql is not available to the user there is no easy way to debug the problem.

I'm sure there are some developers who have had success implementing this tool but it just doesn't seem ready for production. Maybe I had exceedingly high expectations for this tool but there have been similar power user tools around like this for over a decade that have been easier to configure and use. I think I'll have to wait for the next release and try again.

Leif Peterson
philcart
philcart
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4096 Visits: 1436

Leif

Without any idea of your environment or setup I'd take a stab at saying that the report you built returned zero rows due to Report Builders implicit use of inner joins when you have more than one table in the report. Am I close?

I'm close to putting our "end-user" reporting project on hold due to lack of functionality. The current incarnation of report builder provides pretty much same functionality as our current antiquated reporting system. It does add drag and drop functionality, but not much else.



Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface

Australian SQL Server User Groups - My profile
Phills Philosophies
Murrumbeena Cricket Club
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