Split the weekly report for end of the month
I have a requirement to generate a weekly report that will be scheduler to run on Sunday morning (e.g. 03/19/2023) to pull the data for prior week which is the prior Sunday (03/12/2023) to Saturday (03/18/2023). Suppose the month ends in the middle of a week, the week should be split. Two reports should be generated. One report for Sunday to X day and the second report for X+1 day to Saturday. For example, if the schedule runs on Sunday 03/05/2023 then one report should be generated from Sunday 02/26/2023 to Tuesday 02/28/2023 and the second report should be generated from Wednesday 03/01/2023 to Saturday 03/04/2023.
I would like to know how to achieve this in BI Publisher Report. Your help is much appreciated