Hi all,
I have delaeted few prompts from the report and related query,filters everything but if i click on any filter if i click on parameters icon iam able to see old prompt related parameters which iam able to see again in the filter parameters window. so pl get me a solution to delete those.
You have forgot to remove filters related to that prompts. For Eg if prompt was added on a list click on list then go to filters and delete them which contains the parameter of ur deleted prompts ?parameter? .
I did that before but still seeing the paramers in query expression wiondow in paramaters icon.
Check you have used any parameter in query calculation.
no i have not used
Check ,if you have multiple list in the report then other list query may be using same parameter.
Check whether u have created any variables using these parameters.....
Regards,
Royal
I am having the same issue in Cognos 10.2.1. I have removed the value prompt from the prompt page and removed the reference to the parameter in the filter, but the parameter still appears in the parameter list and when I run the report, it causes an addition prompt window to appear requiring an input as if the parameter were still referenced in the filter. I have double checked all filters to make sure the parameter wasn't somehow duplicated in another filter, but I cannot find it.
Did you try searching for it using the Edit > Find feature? Maybe it is referenced in a data item expression somewhere.
Hello,
As Lynn suggests, simply removing the prompt UIs and the filters in the queries would still leave ?Parameter_Name? in the data item expressions in one of the queries somewhere. From report studio, do a Copy to clipboard (Tools > Copy Report to Clipboard)and then paste it into a text editor (Notepad, notepad++) then search for your parameter name. Once you find the text, look at the XML tag it is within, example: a Data Item expression or a filter expression. That's one way I use to figure such things out.
-Cognos810