Hi Friends,
After deleting prompt from the prompt page, there is a parameter still appears when we run the report after feeding in the prompt value to the prompt page. The deleted parameter appears a default prompt page.
Following is the approach that I used to delete the prompt.
1) I first deleted the value prompt from the prompt page.
2) Deleted all filter using the prompt parameter
3) if the parameter was used in Condition explorer I have removed it from there too.
4) if it is used in any data item or layout calculation i have removed it from there too.
5) if it is used on the page for display i removed it from there too.
after eliminating the parameter from the above then too the deleted prompt parameter still appears when i run the report.
Can you advise what am I missing because of which the parameter is still appearing on the report.
Thanks in advance
Regards
Brad
Hi Brad,
It's a bit difficult to know where your parameter is being used, but it's still in your report somewhere. Have you tried looking at the SQL to see if you can spot it in there? The approach you've taken will have hit the most likely culprits...could it be used in any variables for examples?
C
Did u remove All Filters and Query associated to it.
Did you check if there is any conditional styling that references it? Do you have hidden objects that might be referencing it? You can show hidden objects in the View > visual aids menu.
You can use the Edit > Find function to search for reference to the parameter in any expression text. You can get the XML and search for it using a text editor.
Thanks you all for your suggestion.
I have not tried running the SQL. I will try to generate the native sql and check where I can spot these parameter. may be that will give me a clue from where the parameter is lying .
nac, i did remove all the parameter from all the queries in the RS report.
Lynn, removed the parameter from all hidden object in the page and the prompt page. More over I did generate the xml and tried to search the parameter that I deleted. but in the xml there is no trace of the deleted parameter.
I didnt generate the sql may be that could give me a hint to trace the parameter.
If there are no security concerns on your side, post the report XML here, as well as the name of the parameter which keeps popping up as a prompt page.