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


Ad Hoc Query using SSRS 2008 R2


Ad Hoc Query using SSRS 2008 R2

Author
Message
HildaJ
HildaJ
SSC-Enthusiastic
SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)

Group: General Forum Members
Points: 177 Visits: 571
I'm looking for a ad hoc reporting tool for our users. Probably the report builder or crystal report would be a little bit to complicated for our users, so I need something more basic. I supported previously a couple of software packages at my previous employeer where the tool was web based and had a step sequence where the user could create reports. First window, was a list of different views, then the fields selection, sorting, title, etc. the product was more intuitive than report builder or crystal reports. In addition to this intuitive interface, the available views for selection can be modified in a way that fields and tables names are more descriptive (rather than having desc_office it would be office's description). I thought it was part of ssrs but I don't seem to find any information about it. does anyone know a product like that?
Want a cool Sig
Want a cool Sig
Old Hand
Old Hand (318 reputation)Old Hand (318 reputation)Old Hand (318 reputation)Old Hand (318 reputation)Old Hand (318 reputation)Old Hand (318 reputation)Old Hand (318 reputation)Old Hand (318 reputation)

Group: General Forum Members
Points: 318 Visits: 705
Users can use shared datasets in SSRS. Depending on your budget SAP BusinessObjects is really nice for adhoc reports for end users as long as the admin builds the universes correctly. It's web based, you define the object names to be common business names and the users don't have to be familiar with joins or other structures in the database. It's drag and drop into a view area and a filter/where area and it's very intuitive. It's also very expensive.

---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar Hehe
I want a personal webpage Cool
I want to win the lotto :-D
I want a gf like Tiffa w00t Oh wait I'm married!:-D
HildaJ
HildaJ
SSC-Enthusiastic
SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)

Group: General Forum Members
Points: 177 Visits: 571
that is a great solution, I will definetely put it in my list to review. Pricing is an issue, I'll have to check with management when the time comes. Do you know of any other ad hoc queries product that are not as high end as this one?
samalex
samalex
SSC Veteran
SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)

Group: General Forum Members
Points: 216 Visits: 1050
One way of creating Ad Hoc reporting I've been looking at is to build a simple ASP.Net app where I create a list of options for the users to select from then it'll dynamically build the query, run it, and present it for them. Then they can download it to Excel to do whatever they want with it. For some of the canned queries where they just basically select the criteria on what records are returned I hope to go abit further and use SSRS to generate reports with more data like charts and custom highlighting based on various metrics.

So if you have some DotNet experience in your shop this might be an option.
Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16443 Visits: 13202
You can also check out Cognos Analysis Studio. It has a Cognos Framework under it (sort of like the BO Universe) so it's basically drag and drop as well. Simple formulas can be used, just as in BO.

In my experience, Cognos isn't always the fastest solution and I don't think it's cheap either.

You can always check out Excel. Users are already familiar with it and if you have a SSAS cube they can easily build PivotTables. Check out PowerPivot as well, which is a free add-on for Excel and has much more power.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
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