Good morning,
Using Cognos 10.1 - Need a way, like in Excel to allow filtering on any column in my report html output. I found some javascript that will add the filters to each column and show the distinct values of those columns dynamically but need them to filter the other dropdowns (dependent dropdowns or cascading drop downs) Is there anything out there that could do this or does someone know of a tutorial that could teach me how to add this additonal functionality to my existing javascript?
For example
Column 1 has unique product codes
If I select a product code to filter on, the other dropdowns should only show data related to the product code I selected in Column 1.
I am getting it to filter the report overall but the other dropdowns are still showing ALL of the column data, then if I choose something in another column that doesn't have a relation to the product code I chose, the report will be blank.
Thanks for any point in the right direction!
Hi,
This gets a lot easier in 10.2 using the new Prompt API. Is there any chance of you being able to upgrade? If not, I guess the best thing is to wait for a javascript guru like PaulM to notice and provide some guidance :)
MF.
We are due to upgrade to 10.2 in Feb/Mar. Thanks for the tip, I'll read up on the Prompt API! Appreciate the response.
Toni