Hi,
I am new to Cognos 11 Reporting so please excuse the my lack of understanding. I want to filter a particular column in a list without impacting other lists that uses the same query. My background is BusinessObjects which has Query Filters and View Filters. Thanks in advance
I am assuming this is relational data, then you could use a case/if-statement to accomplish this:
Create a Data item "USA" and write the following expression:
case
when [Country] = 'USA'
then [Country]
else null
end
If you want the Data item to filter based on a prompt selection then you could use a prompt macro:
Data item (Country Selection)
#prompt('pCountry', 'string','[Country column]')#
//Oscar
Interesting. So would the prompt affect the entire report or just the specific page?
It will only affect the list/crosstab where you place the data item i.e not the whole report/page/query. It is like a dynamic data item filter.