BI Publisher (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center