Create a view with the filter conditions. Then export the data using export command.
I know of a product that installs as a storedproc in the database that can take a cursor or SQL select statement and deliver a CLOB back in an XML file format that opens natively in MS Excel. I am using it on a project right now, and our users are loving it.
Last Wiki Answer Submitted: October 9, 2009 4:02 pm by Jjohannsen290 pts.