Ok,
One more please. I have a prompt page that iis directed to my Fiscal Year prompt on the quuery. When I run the report i get a prompt for Fiscal year, i enter it, then I get the prompt page also. Why is the report looking twice for the single prompt?
check that the query filter corresponding to the prompt has the same paramater as the prompt
Arsenal.
Yes they are the same, I am stumped. Is there a way to see the resources behind it? Or were it is going? Pulling from?
Copy the report xml source code to a text editor and scan the xml for the parameter
Bloom thank you for the input. I can see a prompt for it in the code but I am not adept and deciphering the issue. Is there an easier way?
Check all the queries where you referred that prompt.. incorrect spelling or change in case also would prompt 2nd time.
Diya,
Thank you, I am sitting here pulling my hair out..lol..
I have deleted all the filters and rebuilt them and I still get the same result, it is like whenever I choose the FY to filter it does it twice. All spelling correct. I have 2 other filters and they are not doing it. Can it be that it is the only one of the three filters that are required?
A filter being required or optioinal will not give raise to such issues. Probably you can try the below steps to actually see what is giving raise to this issue.
1. Delete all the filters that use FY.
2. Take XML and search for that prompt (this ensures that no where this prompt is referred in the report filters)
3. Now run the report, as we deleted the FY from filters, it should not prompt 2nd time (jus to ensure once again)
4. Then add the filter once again (hope you are not typing the filter name, jus drag it from the parameters section.
5. Then run the report once again.
6. If you use FY in more than one filter, then keep running the report each time after adding the filter.
Diya,
Thank you, I did as you stated and it still did it. If I change it to an optional prompt similar to the other two it works fine. Thoughts?
hum.. not sure.. but feel something else is wrong.. coz even if prompt is not mandatory and the filter is required, it wld automatically make the prompt as mandatory when running the report but wld not prompt twice..
That is why I am confused on this one. I am utilizing the report as I have it but, I want to understand the issue as well as it does not make sense.
;D