Categories
Schedule a report with a hardcoded parameter for a parameterized report.
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.
Best Answer
-
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
0
Answers
-
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
0 -
@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)
0 -
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.0
