COGNOiSe.com - The IBM Cognos Community

HI,
     I have generated report that is showing the employee information i want to filter the employee data according to the "CITY" and i have done it  well but my requirement is that how do i filter that data at run time  ???

thanks in advance  :)

Quote from: mohsin2010 on 28 Dec 2010 11:39:20 PM
HI,
     I have generated report that is showing the employee information i want to filter the employee data according to the "CITY" and i have done it  well but my requirement is that how do i filter that data at run time  ???

thanks in advance  :)

Do you mean you want the report to prompt the user for the required cities at runtime? If so, change your filter expression to use a parameter.

Eg. [city] in ?cityparam?

Regards,

MF.

if the city is stored in your authentication source (e.g. Active Directory) you could use this value using a macro
e.g. something like [city]= #sq($account.personalInfo.city)# (<= This parameter must be manually added to your cognos configuration)

HI!
    while creating filter in Tex box prompt i gave parameter name and select operator " in "  the next button remain disable ??? what am i doing wrong ??
  ???

Nothing. There is no next page to go to. Just press Finish.