Passing prompts values from macro to subreports

[cognos4user]

Please, help!

I run macro to pass several values from the macro dialog to several reports and publish them as PDFs. Unfortunately, I could pass these values to only simple reports (objImpRep = objImpApp.OpenReport (strReport, strPromptValues)). If try to use this macro for reports with several subreports, the values are not being passed to the subreports. These reports with subreports behave well though in Impromtu when using regular prompts dialog.

Sincerely,
Dmitry

 

[DoubleD]

Do the subreports have prompts of their own, or are they strictly based on the main report? If they are based on the main report, as long as you include the field you are prompting on in each of your subreports, the filter should be passed.

 

[cognos4user]

Thank you, DoubleD,

I solved the problem. It does work. My problem was that some subreports prompts were something like 'Company, Inc.'and the macro thought it were two values for a prompt while in fact it should be one. I changed that prompt to use another field.