Reporting Data within a 4-4-5 Fiscal Calendar

Question

I am building my first report in SSRS, my company operates on a 4-4-5 calendar. This is a sales report and I would like to run a subscription where the report is sent out daily and update week-to-date and month-to-date sales totals each day based on the 4-4-5 calendar. I have created a separate table which I have joined in my report that contains the fiscal year, fiscal month, fiscal week, start date and end date for each week. I do not know how to write a formula in my data field that would report sales in either a week to date or month to date format. Is this something anyone has experience with and would be willing to help me with?

Answer 1

Hi @Dane Thomas ,
If you select StartDate and EndDate, assuming EndDate is "Today()", when do you want the value of StartDate to be obtained?
In fact, you only need to create the two parameters StartDate and EndDate, filter the data set with the parameter value, and select "Between". You can get any value you want to set in the calendar.
Best Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

would this work if the report would show both a week to date and month to date total? I am aware I can set parameters and prompt the user to select whatever date range they wish. I want this report to be sent out on a daily subscription and update the week to date and month to date totals