Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 User defined reports
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

repairer
Starting Member

8 Posts

Posted - 02/04/2015 :  06:12:13  Show Profile  Reply with Quote
Hi,


First off, sorry if this is worded/explained incorrectly.

I am not too technical or familiar with SQL2005 Enterprise

I run a web application that users can use to run/manage their business, included in this is a suite of reports.

At the moment all the reports are "pre set" in the system, if that is the best word to describe, so effectively the users can only run the reports we offer them.

before I approach the developers who do our development I thought I would try get some advice from users of this forum, my question is..

Could I have reporting function within my web application that would allow a user to "build" their own report? so the user would decide on what data is produced within the report? this would be within reason as I know if it is possible and I allowed large reports to be produced it might "flatten" system resources.

Is it possible? if it is, is it something that is within SQL2005 or is it a third party product.

Hope I explained this so it makes sense.

Any help would be much appreciated.

Thanks

Pete

sz1
Aged Yak Warrior

United Kingdom
555 Posts

Posted - 02/04/2015 :  06:20:52  Show Profile  Reply with Quote
If you are using full SQL product why not use SSRS reporting services and enable/allow the report builder for users to create their own reports via the reporting services site. If they logon to AD they can run report builder local too and publish direct to a specified folder area.

Otherwise for BI you could use SSAS cubes and allow reporting thru Excel and PowerView, although you need SharePoint to run, Power View is now a feature of Microsoft Excel 2013.

We are the creators of our own reality!

Edited by - sz1 on 02/04/2015 06:24:35
Go to Top of Page

repairer
Starting Member

8 Posts

Posted - 02/04/2015 :  06:36:18  Show Profile  Reply with Quote
Hi,

many thanks for the prompt reply, would it be something a non technical person could do? basically the end users have little experience in compiling a report, at the moment the just select a report based on what it is titled, would what you suggest be "user friendly"

thanks

pete
Go to Top of Page

sz1
Aged Yak Warrior

United Kingdom
555 Posts

Posted - 02/04/2015 :  07:04:20  Show Profile  Reply with Quote
You will need someone to setup Reporting Services, ideally seperate to the live SQL instance, this is easy enough by changing the setup to include SSRS, although you would need seperate install for standalone reporting services server, this is better option.

You then need to setup using Reporting Services Config Manager to config the URl, permissions, database...(is the web app internal or external).

The report builder is very easy to use after a few goes users can create simple reports with some assistance. PowerView is really easy to use and is nice to work with and especially easy for end users. If your users have Excel 2013 they can connect to SQL and drag and drop fields, although setting up a SSAS cube would be better as it can be taliored beforehand making it easy for users to see whats what, but thats another bundle of work for your techy guys.

You can get a standalone version of report builder here:
http://www.microsoft.com/en-gb/download/details.aspx?id=6116

Alternatively, use the report builder from reporting services, if you want quick easy reports use PowerView with Excel 2013.

We are the creators of our own reality!

Edited by - sz1 on 02/04/2015 07:07:29
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000