Ad-Hoc Query & Reporting Tool Recomendation RRS feed

  • Question

  • Hi

    which is the best tool in the market for "Ad-Hoc Query & Reporting "


    Wednesday, August 5, 2009 4:52 PM

All replies

  • Hi Kiran,


    The Report Builder within the Reporting Services is a tool used to create AD-Hoc report.


    Report Builder , a component of SQL Server Reporting Services, delivers ad hoc reporting functionality. Report Builder is fully integrated with Reporting Services.


    The Report Builder tool is built using familiar Microsoft Office paradigms so that users can get started quickly. To build a table, matrix, or chart report, use a report layout template that contains predefined data regions and select a predefined report model, which contains report items such as data fields, then drag and drop the report items onto the data regions within the template. Filters can be applied to the report to refine which data gets displayed. The report model contains all of the information required for Report Builder to automatically generate a query to retrieve the requested data. Using Report Builder, users can find data that is related to the content in their report, add text and formatting, create new fields and calculations based on the data in the report model, and preview, print, and publish their reports.


    For more information, please see:

    Report Builder 1.0:

    Report Builder 2.0:


    Please feel free to ask, if you have any more questions.



    Jin Chen

    Jin Chen - MSFT
    Friday, August 7, 2009 6:28 AM
  • I agree with Jin for transactional reporting, but if you're going to be doing Ad-Hoc against OLAP, Excel 07 and Excel services are the low hanging fruit.

    Garth H MCTS: SQL 2008 BI
    Friday, August 7, 2009 2:14 PM
  • Best is really a loaded term and depends on multiple factors including you audience and the functionality you desire.  In other words, different ad hoc tools are better at different things.  Have you nailed down your requirements at this point?
    Friday, August 7, 2009 3:11 PM
  • This is ridiculous!!! How are you going to mark your own answer as THE answer!!!!!!!  Not okay.
    Monday, August 17, 2009 2:03 AM
  • Hi Bryan,


    Thanks for your posting.


    By default, if the owner of a thread does not follow up his (her) thread long time, we will mark one of the replies as answer that will alert the owner that the thread has been updated. Sometimes we may mark ourselves responses as answered to speed up the answer process and also give the post owner a signal for update.

    If the reply does not answer his (her) question, he (she) can unmark the reply.


    In addition, after marking the thread as answer, the thread will be moved to the top of the forum, that any other community members will see the thread simply. May be they have met the same issue before and had a good solution.

    Also, if the answer is not valid, any moderator can unmark it.


    Appreciate your understanding on this.


    Any ways, thanks for your suggestion. Since you have concerns on this behavior, I have unmarked my response in this thread. We really appreciate your continuously contributions in this community.


    Jin Chen

    Jin Chen - MSFT
    Monday, August 17, 2009 8:29 AM
  • Not sure we can actually answer this question in a forum. You might try to learn what 'best' is at TDWI or what not.  A typical solution is to use Gardner, Forrester, or IDC reports to try to gain some perspective.  But frankly, go get the trial versions and see if you like the product.    There's no discussion thread in the world that will tell you if the product is best for you and your requirements.

    Hope that helps,
    Got a bug or feature request? Tell me about it at This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, September 1, 2009 3:40 PM
  • This is the most accurate response to this kind of question that I have ever seen. Thank you.
    Wednesday, March 22, 2017 2:11 PM