Confused Users

[JJayUK]

Hi,

Does anyone know of a front-end app that will allow users to create queries with little or no knowledge of SQL? I'm talking about a Microsoft Query kind of program that allows you to create queries by pointing and clicking but will go off and generate the sql for you on the server.

Anyone know of anything?

Thanks,
JJayUk Regards,
JJayUK

 

[Guest_imported]

What about the query interface in Excel ?

 

[JJayUK]

I'm talking about a *lot* of data, more than the Excel limit. I want to get away from the slowness of the Microsoft Query stuff which doesn't seem to use the server to execute queries. It seems to copy large chunks of the data down from the network which is slow.... Regards,
JJayUK

 

[Rosko]

Business Objects is a good tool for reporting in which the users can build there own reports without any knowledge of SQL. My previous firm uses it and it works quite well


Rosko

PS: This is not commercially intended