title: Dynamically change column names as week number on every weekly run
body: <p>I want to build a SSRS report that has column as week numbers - 8 weeks for 8 columns starting with current. This report is run every week and current week number is set then. So both column names and their values should change .Is it possible to build something like this in SSRS?</p>
  
  <p>I tried doing this with a dynamic SQL based stored proc in dataset. However for every run I don't even see the columns values updating dynamically</p>
  
  <p>Here's an example :</p>
  
  <p><a href="https://i.stack.imgur.com/BtvWW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BtvWW.png" alt="enter image description here"></a></p>
  
  <p>Also I am trying to avoid these week numbers as row  values and then using matrices</p>
  
  <p>My stored proc looks something like this</p>
  
  <p>declare @n tinyint = datepart(wk, getdate())</p>
  
  <p>declare @n1 tinyint = (@n+1), @n2 tinyint =(@n+2), @n3 tinyint =(@n+3), @n4 tinyint =(@n+4), @n5 tinyint =(@n+5), @n6 tinyint =(@n+6)</p>
  
  <p>exec ('Select b.sku, b.['+@n+'], b.['+@n1+'], b.['+@n2+'], b.['+@n3+'], b.['+@n4+'], b.['+@n5+']...</p>
  
  <p>Will appreciate any help in this direction.. many thanks!</p>