Schedule a report with a hardcoded parameter for a parameterized report.

Summary:

I have a report with a parameter for start and end dates. Now, the user wants to have a scheduled report with hardcoded values, like April 1, 2024, as the start date and the current system date as the end date. Instead of creating a new report with these hardcoded values, is there any way I can achieve this in BI Publisher?

Can we change the SQL query during the execution of scheduled job reports only?

If yes, please share a simple code snippet on how I can achieve this.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):