Joseph Blank
Top achievements
Rank 1
Rank 1
Joseph Blank
asked on 11 Feb 2013, 01:04 PM
I just installed version 6.2.13.110 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?
Any idea why it is missing?
6 Answers, 1 is accepted
0
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.
Greetings,
Steve
the Telerik team
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.
Greetings,
Steve
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!
0
Gord
Top achievements
Rank 1
Rank 1
answered on 12 Apr 2013, 02:56 AM
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.
Gord
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.
Gord
0
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,
Stef
the Telerik team
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,
Stef
the Telerik team
Have you tried the new visualization options in Telerik Reporting Q1 2013? You can get them from your account.
0
Paul D.
Top achievements
Rank 1
Rank 1
answered on 19 Sep 2013, 12:09 AM
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.
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.
0
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.
Regards,
Stef
Telerik
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.
Regards,
Stef
Telerik
Have you tried the new visualization options in Telerik Reporting Q2 2013? You can get them from your account.
0
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.
Regards,
Peter
Telerik
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.
Regards,
Peter
Telerik
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.