Visual Query Generator
Posted: Thu Oct 21, 2010 10:58 am
We chose this web based software for our end users, and they really like the UI and the ability to create adhoc reports. I am impressed with the UI.
All of my customers (many are not DBA's) are asking if there is a visual query generator that can be used with this other than running SQL Administrator so that they can create quick views and reports. Many are used to working with SSRS and they have a graphical query builder much like MS Access. Our goal is to keep them in the UI without having to resort to tools.
Is there plans for this, at least to be able to select different tables from the data set so that they can see what table to choose from the database connection. Currently they have to write SQL to get the dataset.
All of my customers (many are not DBA's) are asking if there is a visual query generator that can be used with this other than running SQL Administrator so that they can create quick views and reports. Many are used to working with SSRS and they have a graphical query builder much like MS Access. Our goal is to keep them in the UI without having to resort to tools.
Is there plans for this, at least to be able to select different tables from the data set so that they can see what table to choose from the database connection. Currently they have to write SQL to get the dataset.