We have had a problem of multiple machines dropping R:Base in multi-user while creating complicated reports and we are working our way through it. In RBase-l archives, we keep finding suggestions on isolating users. I just changed all our PROJECT commands to TEMP TABLES WHERE LIMIT = 0. Previously used SomeID = 0 which works, but I see how LIMIT can avoid some conflicts which could lead to our problem. Now all REPORTS are being converted to TEMP VIEWS. The smaller reports work great. I am working toward a very large report (15-20 pages) which summarizes a lot of data. It is based on 12 table/views, 7 of which are multi-table views. Several questions:
1. Is it better to create new TEMP VIEW for each individual data table being used (major rewrite needed) or TEMP VIEWS of the existing VIEWS (minimal rewriting)? I assume regular VIEWS are functionally like TABLES. 2. Is there some way to create the TEMP VIEWS with the Query Builder then reload them on the fly using variables or just use QB to build the SQL code that creates the TEMP VIEWS before running the report? I have worked on this before and sometimes the light bulb of understanding just takes a while to come on. Tom Frederick Jacksonville, IL
