Print Page - How can we pass macro filters value from URL to Cognos reports?

Title: How can we pass macro filters value from URL to Cognos reports?
Post by: Vishnu Thogulu on 08 Oct 2010 05:05:08 AM

Hi Techies
Usually prompt values are passed by &p_Paramatername=value or in the encoded form. It is working for general paramterized filters but not for filter with macros.
My filter is like this,
#prompt('Parametername','token','[TIMESTAMP_VALUE] = 2000-01-01T00:00:00')#

This filter is included for creating reports to find out the data for last month, last year etc (data grouping prompt). My value prompt has static choice.

Any idea?

Thanks
Vishnu

Title: Re: How can we pass macro filters value from URL to Cognos reports?
Post by: pricter on 08 Oct 2010 06:54:06 AM

Did you try to urlEncode the passing parameter value?

I had a similar problem where a value contained '+'. I used urlEncode and then the value was passed successfully.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Vishnu Thogulu on 08 Oct 2010 05:05:08 AM