Hi everyone,
i am using cognos 10 with teradata
I would like to have an single input text field in the prompt page where the user can copy paste coma separated values of ID numbers and can be used directly in the an IN type filter
For example
user enters : 12312312,4321123 etc
and in my filter i have
[ID] in (?values?)
What syntax do i need in my filter to execute this ?
In addition , what would it be possible to have file upload of text file which new line separation and work in similar fashion ?
Hi there
Assuming that you have a Text Box Prompt and a parameter named MyParameter then you should be able to use this in your report filter:
[The Field Name Goes here] in (#csv ( split ( ',', prompt('MyParameter','token') ) ) #)
Hope that helps.
Cheers
Dax