Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

The Report Builder Expand / Collapse
Author
Message
Posted Friday, August 25, 2006 4:21 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: 2 days ago @ 9:01 AM
Points: 6,705, Visits: 1,680
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
Post #304275
Posted Monday, August 28, 2006 8:09 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 30, 2006 11:06 AM
Points: 11, 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.

Post #304445
Posted Monday, August 28, 2006 8:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 5:37 PM
Points: 1, Visits: 52
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.
Post #304461
Posted Monday, August 28, 2006 9:01 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 10:28 AM
Points: 583, Visits: 931
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
Post #304467
Posted Monday, August 28, 2006 10:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 11, 2008 1:22 PM
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

Post #304504
Posted Monday, August 28, 2006 12:19 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 15, 2013 9:12 AM
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
Post #304540
Posted Monday, August 28, 2006 1:09 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: 2 days ago @ 9:01 AM
Points: 6,705, Visits: 1,680
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
Post #304553
Posted Tuesday, August 29, 2006 8:07 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 2:01 AM
Points: 2,693, Visits: 1,173

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
Post #304666
Posted Wednesday, August 30, 2006 5:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 22, 2013 1:27 PM
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
Post #304912
Posted Wednesday, August 30, 2006 8:08 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 2:01 AM
Points: 2,693, Visits: 1,173

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
Post #304991
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse