Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Feature comparison for Report Builder with other adhoc reporting tools


Feature comparison for Report Builder with other adhoc reporting tools

Author
Message
Dutta, Amartha
Dutta, Amartha
Valued Member
Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)

Group: General Forum Members
Points: 65 Visits: 110
Dear Forum Members & Guest viewers,

Requesting your help in directing or providing me with some texts / links or materials in any or all formats to know about the feature comprison between SQL server 2005 report builder and MS - Access and / or Crystal Reports.

Actually I am preparing a presentation on Report Builder for imparting training to a set of IT Managers and Administrator who are currently using MS Access / Crystal Reports for generating Adhoc Reports. In order to give them a better understanding I want to tell them the advantages and disadvantages too of using Report Builder as compared to other above mentioned reporting tools.

Looking forward to your kind help and suggestions.

Thanks A Lot.
GOD bless you and all...
sql_lock
sql_lock
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1784 Visits: 1929
http://www.devx.com/codemag/Article/36397

http://www.silicusblogs.com/kb/software-development-platforms/dotnet-software-development/a-comparative-analysis-of-sql-server-reporting-services-and-crystal-reports.html
Dutta, Amartha
Dutta, Amartha
Valued Member
Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)

Group: General Forum Members
Points: 65 Visits: 110
Thanks sql_lock for the quick reply. Quite a help in building the basics.
The article seems to be more on comparison with SSRS. Can you please guide me in having some article which deals with comparing Report Builder with Crystal Reports / MS - Access report?

Additionally can you please let me know where I can download PDF tutorials for taking Report Builder from Novice to expert level.

Thanks a lot once agains for your kind suggestion and help.
Thanks
sql_lock
sql_lock
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1784 Visits: 1929
Report builder itself is for novice users (with the exception of formula's - but anyone with Excel exp can pick these up pretty quickly).

IMO, keep report builder simple for end users to get data from a well defined model.

A model can be based on a view of collection of tables. Make this easy to use so that users understand the data that is being returned!

For more complex reports that require SPs then you will need to use the report tool within Visual Studio (shipped with SQL 2005/20080. These can be difficult to novices and I would advise looking and the MS sites and/or buying a book (some good ones out there).

The building for a report with CR is not really for novices (IMO), but more for intermediate/experts.

If your going with SSRS I would advise to make various "models" for different areas of the business, so that each end user can create their own reports (my training for this only takes 1 hr) and see the data relevant to their job/role! Implementing this has cut down data requests to systems by 70%, as data wasn't easily extracted from the DB.


Report builder tutorials
http://msdn.microsoft.com/en-us/library/aa337398.aspx

Hope this is clear???
Dutta, Amartha
Dutta, Amartha
Valued Member
Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)

Group: General Forum Members
Points: 65 Visits: 110
Thanks sql_lock for your marvellous support.

Hope I can give better touch to my presentation now.

Thanks a lot once again.
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