Report - Parameter Tab

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?

I wouldnt expect you would be able to reference a different parameter in a parameter, but couldnt you simplify with something like this?

Report parameters are initialized/evaluated in the order defined. If enddate is below startdate in the list, startdate cannot use enddate.

1 Like

I agree. In my case, endDate is above startDate in the list, which means that it should evaluate first, but its still not working

I'm trying to have report evaluate the startDate based on the endDate. If I were to use your suggested method I would have to make a new schedule and hard code it for each date and time.

Hmm. Not sure what's going wrong. Consider using a script data source to set the start date.