I remember a thread a while back about recovering space from BusinessObjects reports. We are experiencing a problem in that, even when we purge a report, it still takes up the same amount of space. This is causing a problem as we want the reports to be fast loading and, also, we want the reports to contain only information relevant to the user. in other words, we want the user to import a blank report, run it with his or her user id so that the security features will work, and then only be able to see the data for him or herself.
My suggestion would be to duplicate the report from scratch and use the ‘DO NOT RETRIEVE’ data option. Run this report. this will generate the report with ‘EMPTY’ cells. You can change the formatting (using your earlier report) by applying templates, or just modifying them again.
Once you have the report the way you want it, Change the option on it to ‘REFRESH UPON OPENING’. This will refresh the report for the user as it is opened (allowing your security to do it’s work).
As long as this ‘empty’ report stays in the Repository, you should be set…