Here's another idea I had put together a simple Reporting grid app for our end users;
it's a windows app featuring the DevExpress Report Grid;
on the left, it has a list of all the "public" VIEWS int he database that follow a naming convention of "VW_{viewname}"
the DataGrid is ReadOnly, every time they add a filter to the Dev Express Grid, a SQl query for the view is modified to be ready if they hit the Run button. It also does a Limit of TOP 1000 Rows (order by 1 if no sorting is selected on the grid)
since the grid has the ability to save to just about any format, that works pretty well for us so far;
If someone needs a new "report", someone lime myself just needs to create a view, test it, and then rename it to the naming convention to be immediately available.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!