Query Builder missing from SQLDataSource wizard

7 posts, 0 answers
  1. Joseph Blank
    Joseph Blank avatar
    3 posts
    Member since:
    Aug 2004

    Posted 11 Feb 2013 Link to this post

    I just installed version of the Report Designer.  According to the documentation, when adding a SQL Data Source, there should be a "Query Builder" button on the "Configure Data Source Command" screen.  This does not appear to be the case - see attached file.

    Any idea why it is missing?
  2. Steve
    Steve avatar
    10941 posts

    Posted 12 Feb 2013 Link to this post

    Hello Brian,

    Currently the standalone Report Designer does not provide the query builder that you're used to from the integrated Visual Studio Report Designer. As the query builder is part of Visual Studio, we can't include it in the standalone designer. This means we have to implement our own query builder which as you can imagine is not a trivial task. As we consider the standalone designer as integral part of the product and as such is mainly aimed at developers and power users, this functionality is not in our short term plans and we cannot engage with a specific time frame or additional info at this point.
    the Telerik team

    HAPPY WITH REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

  3. Gord
    Gord avatar
    4 posts
    Member since:
    Nov 2012

    Posted 11 Apr 2013 Link to this post

    Hey Steve, 

    That last sentence really doesn't make sense and I was also not given an impression from marketing materials that the standalone designer was "power user" only.  The first part of your response was good but then maybe leave out the power user bit and instead maybe suggest an alternative such as using the query builder in sql express reporting and cutting and pasting the string.

    Or perhaps there is an updated learning guide that pertains to the stand-alone designer?  That would keep people like myself and Brian from looking for a Query Builder button.

  4. Stef
    Stef avatar
    3611 posts

    Posted 16 Apr 2013 Link to this post

    Hi Gord,

    You can import an already created with Visual Studio reports in the Standalone designer, or use templates with preset SqlDataSource components. In addition you are free to use any outer query builder or create your own. What we wanted to say is that if the Standalone designer is used for retrieving data with SQL queries some knowledge about SQL syntax is required. Still another approach is to use the OpenAccess ORM and access the model objects with the OpenAccessDataSource component or utilize an already prepared stored procedures. 

    In order to avoid further misunderstanding we will update our documentation to point there is no Query Builder for the SqlDataSource in the Standalone Designer.

    Kind regards,
    the Telerik team

    Have you tried the new visualization options in Telerik Reporting Q1 2013? You can get them from your account.

  5. Paul D.
    Paul D. avatar
    7 posts
    Member since:
    Dec 2010

    Posted 18 Sep 2013 Link to this post

    It would be nice to see a Query Builder added to the Stand Alond Report Designer.
    We're evaluating what method we prefer to use in building our web systems:  stand alone .trdx files or integrated dlls.

    Both methods have their pluses and minuses.  But not having the query builder is a fairly strong negative against working with stand alone report files.  Honestly, I'm not sure anyone can build a report generator than "non-technical" types can use. 
    it's just not a trivial task.  So why not give the stand alone builder as much functionality as possible.

    I understand though that a query builder is a substantial amount of work.
  6. Stef
    Stef avatar
    3611 posts

    Posted 19 Sep 2013 Link to this post

    Hi Paul,
    The query builder is part of Visual Studio. Thus we can't utilize it in the standalone Report Designer. You can rest assured that we are considering the implementation of a functionality that will replace the need of a query builder.

    Notice you can provide the end-users with already built data access layer in an external assembly referenced by the Standalone Designer and thus avoid the need of writing queries by hand.

    Other possible solution is to use Report Templates containing data source components in them with predefined queries, or use any SQL based environment to test the queries before passing them to the Standalone Designer.

    Of course you are free to search for outer implementations of query builders that can be used.


    Have you tried the new visualization options in Telerik Reporting Q2 2013? You can get them from your account.

  7. Peter
    Peter avatar
    1631 posts

    Posted 29 Oct 2014 Link to this post

    Hi Paul,

    In Q3 2014 the Standalone Report Designer provides a Query Designer to help you create queries to retrieve data from a relational database. Use the query designer to explore the database tables and views, interactively build an SQL SELECT statement and view the result of your query.


    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

Back to Top