Filter Report At Run Time !

[mohsin2010]

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  :)

[MFGF]

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.

[sir_jeroen]

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)

[mohsin2010]

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 ??
  ???

[MFGF]

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