0

I want to display the header of my ssrs report in the format as in excel... Ignore the details in the table :) I am trying to display the DAY1, Day2 header in my SSRS as shows in excel. Logic Says (if today is working day then until the last working day +1 it should display Day1 else, minus 1..basically Business days is calculated. Hope the picture is clear below.

enter image description here

Tried doing this in SSRS. enter image description here

enter image description here

enter image description here

I Want to last image to display the same as the first one, that is taken through Excel.

Please help.

Ruchi
  • 146
  • 1
  • 8
  • 1
    You're going to need another level of **COLUMN Grouping** that's based on a formula to calculate business days. That will group by the Day# as in the Excel example. Here's a formula: https://stackoverflow.com/questions/21706897/ssrs-2008-datediff-for-working-days – Hannover Fist May 22 '17 at 23:39
  • This is not solving my purpose..It give the difference between the dates, whereas i have condition for business days and holidays. – Ruchi May 30 '17 at 07:18

0 Answers0