title: SSRS report showing different record to different user. How can this be implemnetd?
body: <p>I recently encountered a requirement which said "Manager should see all record but Associates only appropriate subset. I will explain my requirement with below example.  </p>
  
  <p>I have a table.</p>
  
  <pre><code>CREATE TABLE [dbo].[Empolyee](
      [EmpID] [int] NOT NULL,
      [Name] [nvarchar](50) NOT NULL,
      [Salary] [int] NULL,
      [Grade] [char](1) NULL
  )   
  </code></pre>
  
  <p>and some data</p>
  
  <pre><code>insert into Empolyee values(1, 'John', 200, 'C')
  
  insert into Empolyee values(2, 'Jim', 100, 'D')
  
  insert into Empolyee values(3, 'Jane', 500, 'A')
  
  insert into Empolyee values(4, 'Jack', 150, 'C')
  
  insert into Empolyee values(5, 'Jil', 300, 'B')
  
  insert into Empolyee values(6, 'Josh', 350, 'B')
  </code></pre>
  
  <p><strong>A</strong> is the highest grade, <strong>D</strong> is lowest.</p>
  
  <p>I want to employee detail report in SSRS</p>
  
  <p>simply showing </p>
  
  <p>select * from Empolyee.</p>
  
  <p>Now the requirement is user should be able to see his/her record and people at lower Grade.</p>
  
  <p>E.g.
  If Jane see report she see should see all 6.
  If Jack see report she see should see only 2(his and Jim's) </p>
  
  <p>I could see this is case of role based security but how to implement this? </p>