How to pass prompt values from a macro to sub-reports?

[cognos4user]

Does anybody know how to pass prompt values to sub-reports or it's out of question when using macros? It looks like that 'OpenReport' method does not apply to sub-reports or it does but does not pass values to sub-reports or I am completely off the subject. Please, give me any idea on this account, I am new to writing macros for cognos.

Cheers,
Dmitry

 

[griffindm]

cognos4user,

Never even considered putting a prompt into a sub-report before . Usually I filter the sub-report based on prompt values in the main query. Try defining a calcuated column in the main query to be equal to a prompt you define there, and then use this in the sub-report instead. This column does not have to be visible in the report to make this work. This should fix the issue of not being able to feed the prompt value into the sub-report via the macro.

Hope this helps,

Dave Griffin


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

http://www.decisionsupportgroup.com

 

[cognos4user]

Thank you, Dave for the prompt response(). I realized that the macro should work in my case and the problem was that several prompts were using values with commas, e.g. 'Company, Inc.'. This likely confused my macro into thinking that there were two values passing to the prompt instead of one and the report did not display anything (). I have to switch prompts in the reports to using something like company code which I hope will fix the problem.

Dmitry

http://www.getintegrated.com