Print Page - Prompt , parameter and filter issue

Title: Prompt , parameter and filter issue
Post by: learnflower on 11 Jun 2012 07:44:30 AM

Hi ,

I have an issue which deals with all the 3 of Prompt , parameter and filter .

I have products code which like AMPRTY , AMMAR i need to display in paramter only first 2 letters of it . this products are there in different branch so when i select checkbox as AM in the prompt it need to get all products starts from AM irrespective of the branch it is in .
I am giving subsrting(product_code,1,2) in ?product_code?

Please help me on this

Thanks in advance

Title: Re: Prompt , parameter and filter issue
Post by: blom0344 on 11 Jun 2012 09:14:47 AM

Can you please provide us with information about the part that does not work?

substring(product_code,1,2) in ?product_code?

would indeed fetch all codes starting with 'AM' when you use 'AM' as promptvalue

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: learnflower on 11 Jun 2012 07:44:30 AM