COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: srinu_anu2007 on 13 Sep 2012 12:51:23 AM

Title: Select and Search Prompt
Post by: srinu_anu2007 on 13 Sep 2012 12:51:23 AM
Hi,

i have prompts which is f.name , l.name, subsc, patient and provider as per requirement saying combinle

f.name and l.name for mem,
subsc, patient and provider into one data column and use the prompt select and search prompt

How can i do. it is it possible to make multiple prompts into single prompt.
ples suggest on the same.

Thanks.
Title: Re: Select and Search Prompt
Post by: HalfBloodPrince on 13 Sep 2012 03:45:42 AM
For combined First name and Last name first create  calculation as  First_name+ ' '+ Last_name then add prompt on this calculated column