Hi all,
I'm trying to generate a report on the first and 16th of the month, 12:05 AM. I have 2 parameters, startDate and endDate. On the 1st of a month, I would like it to report data from the 16th - last day of previous month. On the 16th of a month, I would like it to report data from the 1st - 15th of the same month. Using a midnight-to-midnight timeframe here.
Here's the approach I want to take:
Approach 1
But apparently the reporting module doesn't accept endDate as a parameter inside the startDate expression and gives me a warning similar to the following:
So I'm taking a longer approach which works for me:
Approach 2
Approach 2 above feels redundant in nature and confusing to understand on the first look. Hence, I prefer approach 1.
Can anyone guide me if I'm doing something wrong? Or is this the limitation of the reporting module? Maybe there's a better approach?