SSRS/ SQL security over client's site
<p>I was wondering if anyone can help. I have started a new job for a firm where they are looking to create BI reports for clients. The clients have the server on their site. We have access to only query the data, but not allowed to create tables, stored procedure etc.However we are allowed to create temporary tables.</p>

<p>I am looking to create an SSRS report for the client but at the same time want hide the SQL from them to prevent them knowing how the reports are built.</p>

<p>Is there a way to create a self service bespoken report which I can deploy for them but keep the SQL hidden from them, despite them having the server on their site and them having admin access to the sql server box and SSRS reporting server?</p>

<p>Any advice on best handling this tough situation will be greatly appreciated!</p>