Solved

Ad-Hoc Reporting Tool for Non-Technical Users

Posted on 2010-11-18
4
137 Views
Last Modified: 2013-12-14
I am looking for advice on giving my non-technical users the ability to create their own reports.  For example, a user may want to include client name, phone number and address but not social security number.  But anothe user may need all 4 fields.  I would like a tool that allows my users to drag and drop fields ultimately making an ad-hoc report.  This is a very simplified example and our data goes across many tables.  So I would need the ability to give them the field data based upon complicated SQL views that IT writes but the user just needs to drag and drop what they need.

Does anyone know / use a product that does this?  No sophisticated graphs or anything is needed.  Just simple columns of data that can be brought into excel for further manipulation.
0
Comment
Question by:melikins
4 Comments
 
LVL 5

Accepted Solution

by:
dacasey earned 500 total points
ID: 34170029
Have you setup an ODBC connection and used the query tool in Excel. It's about as simple as it gets....
0
 

Author Comment

by:melikins
ID: 34170151
No, I wasn't aware of it.  Does it allow you to drag and drop fields?
0
 
LVL 22

Expert Comment

by:Steve Wales
ID: 39718518
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Unable to save view in SSMS 21 59
T-SQL:  I Want "Summary"--Not "Detail" 6 22
T-SQL: Nested CASE Statements 4 24
Update SQL to SP1 on SCCM server 7 16
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now