At 12:23 AM 2/13/2003, Dilip wrote:
Actually lots of users are connecting to this database from remote locations and connections are very slow because of network. So these clever people wants some sqls/reports to be run from ODBC connection and get data into excel and then work on that data. So that they don't need to access database full day.Have you considered a reporting tool like Brio or Crystal Reports? You can define reports that users can run whenever they like or have those reports pushed out to them on a schedule when database activity is lower. You can present the reports as HTML, or download them as CSV's for Excel. It's a little more work up front, but it's well worth it IMHO, particularly for non-technical users.
Now I am suggesting them that we should create views in the database. Views definition will take care of report logic. And then through ODBC, they will just do 'select * from view_name' and get data in excel and carry on.
Justin Cave
Distributed Database Consulting
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Justin Cave
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
