A reason to base reports off permanent views rather than temp tables is because a user can click on a report in the database explorer and the thing would work. But now that we have "on before generate" eeps, you can base a report off a temporary view rather than a permanent one. You can even have the eep ask you for a variable to use in defining the view.
Karen > Thanks for the ideas. Declaring vars in a ViewVars so they are in memory > before reloading makes sense and seems easy. Using Emmitt's idea of > moving to temp views would also work for most situations. Most of our > reports use views based on 1-2 tables which are pretty simple. I do have > several large ones (12-18 pages) packed with hundreds of text, note, and > integer data items from 18 different tables with heavy use of views, > regions and subs. You have given plenty of new ideas to work on. I > appreciate it. > > Tom Frederick
