I dont know of any way to prompt in the report action, but if your goal is to make it user specific, we usually use a SQL statement to achieve this. Example below uses a function to determine the path based on the logged in user (actual logic for the path is in the function)
SQL:SELECT JIS_F_GET_EXCEL_PATH_CP($[USER],$[$BOY_1.customer.0]) FROM DUMMY
i suppose if you really needed to have a prompt, you could do something similar, have a UDF on the user, overwrite it using a prompt (which you would need to somehow trigger before your report action) and use the path in the UDF during your Save as PDF report action.
Comments
1 comment
I dont know of any way to prompt in the report action, but if your goal is to make it user specific, we usually use a SQL statement to achieve this. Example below uses a function to determine the path based on the logged in user (actual logic for the path is in the function)
SQL:SELECT JIS_F_GET_EXCEL_PATH_CP($[USER],$[$BOY_1.customer.0]) FROM DUMMY
i suppose if you really needed to have a prompt, you could do something similar, have a UDF on the user, overwrite it using a prompt (which you would need to somehow trigger before your report action) and use the path in the UDF during your Save as PDF report action.
Please sign in to leave a comment.