November 22, 2006 at 3:29 am
I am setting up the SQL2005 reporting service to let users build their own reports on the web. I'll provide them with pre-built report models. We have concern with SQL database performance by allowing users to execute huge reports. The problem that I have is: If I give the users permissions to build report they'll have access to the report's Properties | Execution page, which allows them to disable the report execution timeout. Is there a way for me to allow them build reports while restrict them to access the report execution timeout settings?
Please advise. Many thanks.
November 27, 2006 at 8:00 am
This was removed by the editor as SPAM
November 27, 2006 at 7:55 pm
you could set the timeout on the Site to a sensible number this should override whatever they put in their report. You can give them the Report Builder role but not enable 'Manage report server properties' for them in the system roles. That way they can't alter the report server property... But then everyone has the same default...
Failing that is there anywhere in the Model this can be set?
Martin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply