passing filter definition

[ornel]

Hi All,

I have got a simple report with 2 columns (id,text) without any filter definition.

I call this report from macro, and a macro create an filter definition (before call the IMR), for example ID=1.

I would like to pass to the report the filter definition from macro.

How Could I modify the report filter definition from macro?

Can someone help me with this?


thx ornel

 

[griffindm]

ornel,

See faq401-2137 and the subsection called "Macros and Prompts". Prompts are passed from the macro as strings. They must be defined in the report as a string. You can do conversion within the report if they need to become other data types.

Hope this helps.

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com