I have a main report linked to a sub report. The customer can run the main report or schedule the main report.
So here my question is how to create the open document url (with refresh on open option or with the latest instance option)?
How to change this dynamically based on how the user is accessing the main report?
Because if customer runs the main report on-demand and clicks the hyperlink then it should open the sub report (with refresh on open) option and fetch the latest data.
if customer schedules the main report and clicks the hyperlink then it should open the latest instance of the sub-report.
How to achieve this?