title: How to display data for individual days in SSRS
body: <p>In my database, I have the data in the below format:
  <img src="https://i.stack.imgur.com/DUD6x.jpg" alt="Database View"></p>
  
  <p>and in my SSRS (2010) report, I need too show the data in the below format.
  <img src="https://i.stack.imgur.com/oiVjd.jpg" alt="enter image description here"></p>
  
  <p>My question is: 
  We have data in the database for each bussiness date. In the report the data is shown horizontally (Sunday - Saturday)..
  So, when returning data from the DB, should I create individual columns for each day, update them with the data depending on the date and return it
  in individual day columns(individual columns for each day).. or is there a way we can do that in SSRS?
  The first option looks easier to do but not sure if it would be the right design.</p>