title: credential in reporting service
body: <p>I have a problem about the credential in reporting service..
  When I choose option <code>windows authentication</code> for a report in <code>SQL Server Reporting Services</code>, only the administrator can view the report. The other users can't view the report. But when I set <code>credential stored securely in the report server</code> and enter the username and password, all users can view the report but some data of the report is not showing. </p>
  
  <p>For your information, I have created the user in SQL Server and I have set the role and user mapping.</p>
  
  <p>What should i do?</p>