Hi all,
Still fighting against cascading prompts...hehe...
but now I made an important discovery.
I create a cascading prompt in this way (as u all suggested me):
--Drag&Drop a value prompt on a prompt page;
--Create a New Parameter;
--Select the proper Package Item...
And the issue is properly at this point, when selecting a Package Item.
I realized that if the Data (Columns) of the Report come from the same Package Items, everything works.
For example, the data in the Report are:
OBJECT CLASS ORGANIZATION (All from R5OBJECTS Package Item)
and then I select ORGANIZATION for the Cascading Prompt from the same Package Item, the cascading prompt works!
But if the Data of the Report come from a Query that I wrote (even with the same data: SELECT OBJECT, CLASS, ORGANIZATION FROM R5OBJECTS), but I choose ORGANIZATION from the R5OBJECTS Package, the Cascading Prompt does not work!!!
Maybe i have not been clear but this is how it works!
So what is the solution?
How can I create working Cascading Prompts when my Data in the Report are not selected from the Package Items but from my Queries???
Thanks in Advance.
Ciao
Matty