Is there a possibility to have Graphical Query Designer in Report Builder 3.0 in case the connection is made to an Oracle database (through .NET Provider for Oracle for example)?
I need to offer to the end users the means to build their own reports.
Every user has associated a group of database objects and as soon as users are added new database objects are added. Therefore I cannot create a model because it needs to be changed frequently and the model in this case would contain objects to which the
user does not have access.
The only option is that the user should create his report query in a friendly manner.
So the query text editor is of no good in this case.
I've found in documentation that for Oracle and other databases there is no Graphical Query Designer:
In Report Builder 2.0, to specify a query for data source types Oracle, OLE DB, ODBC, and Teradata, you must use the text-based query designer (http://msdn.microsoft.com/en-us/library/dd220607(SQL.100).aspx).
Is there a way to have Graphical Query Designer in Report Builder 3.0 or should I look for other products?
In case Report Builder cannot solve this problem can you make some product recommendations - ad-hoc web reporting for .NET?
View Complete Post