Hi, could someone let me know how picklist prompt could be done in Cognos 8 just like in Impromptu.
Thanks
It can't be done just like Impromptu.
However, Cognos has a proven practice document called "Saving Picklist Values to a Local File for Reuse", which may give you what you want...it was for ReportNet but hopefully still works in C8.
another potential solution would be to add an HTML item to the report prompt page and populate your known values via javascript. you could also do this by creating a template query for this value prompt control and use it in future reports.