Posted By: khang Can't unlock Report - 11/10/23 03:04 PM
Hello,
I with some locked report, when I click now on the unlock button, nothing happen. I d'ont even have the password dialog.
But if I try to execute the reports, it works as usual.
What tricks do I miss as I need to retrieve the original SQL.
Posted By: Marco Kalter Re: Can't unlock Report - 11/13/23 09:33 AM
This report is probably only unlocked when connected as the user from the report options.
Posted By: khang Re: Can't unlock Report - 11/14/23 02:47 PM
Is there a way to know who is the user in report options ?
Posted By: Marco Kalter Re: Can't unlock Report - 11/15/23 09:28 AM
No, this information is unfortunately not visible. You can only view or edit the report definition when connected with the user from the report definition.
Posted By: mike Re: Can't unlock Report - 11/16/23 04:24 PM
If you are just needing the original SQL, I found the reports in %APPDATA%/PLSQL Developer Common. Then I can open it with a text editor and the SQL is there.
© Allround Automations forums