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

NEWBIE

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.

Mallikarjuna Kuppauru-Oracle

Hi @NEWBIE ,

Yes its works for system date conditions

first one is an interactive report where users input their own date range values, and the second one is where values are hardcoded. —> Both Cases you need to pass the values are Date parameters.

For Dynamic Selection you need to calculate the Date value based on System date.

Regards,

Arjun

Mallikarjuna Kuppauru-Oracle

Hi @NEWBIE

You can use the buildin date functions dynamically to pass the required values. For example -

 Today: {$SYSDATE()$}
 Yesterday: {$SYSDATE()-1$}

Refer - How to Schedule a BI Publisher Report with Dynamic Date Values (Doc ID 1410194.1)

Regards,

Arjun

Sumanth V -Oracle

@NEWBIE - Please refer the below document which should help achieving your requirement:

How to Schedule a BI Publisher Report with Dynamic Date Values (Doc ID 1410194.1)

Configuring Parameter Settings for the Report

NEWBIE

Hi Guys,

Thanks for the response. In my case, the first one is an interactive report where users input their own date range values, and the second one is where values are hardcoded.

The solution provided works for sysdate conditions.