I have a free hand sql report with several prompts, business needs two prompts removed. Although i removed them from the script they’re still visible on the list of prompts when I run the report. I cleared cache, did a save as and they are still there. How can I remove the two prompts permanently?
There may be something related to them built into the report in addition to in the SQL. Look through the list of objects created for the report and see if there is anything listed there.
Thanks for your help, but I found the solution, go to Properties==>Document remove the check mark on Allow Query Stripping .