dynamic parameter prompts

[crsdev]

Hello friends, i was hoping someone has answer to this:

When I use dynamic paramteter prompts, I get prompted to enter the DB login when viewing the reports in InfoView; but When I use the static prompts the report runs fine. How can I make the DB password prompt not to appear?

I've already added the password in
CMC-->Home-->Folders-->report-->Process tab-->Database ..password.

Thanks for any help in advance.

 

[MJRBIM]

Dynamic Parameters create Business Views on the Enterprise server when the RPTs are posted. Those Business Views need to be managed...

Look at this thread -

http://www.tek-tips.com/viewthread.cfm?qid=1356363&page=1

 

[crsdev]

Thanks MJRBIM (MIS)
after going through it, I am still not able to make the report work without entering the DB password.
My BV Manager version is 11.5.3.417.
Would it be possible for you to provide the step by step instruction to overcome this .
---thank you very much.

 

[Turkbear]

Did you use the Publishing Wizard to add the report to the BOE system?

Usually that handles the connections as it is published and saves the user/pass you used to create the LOV..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[crsdev]

Thanks Turkbear, I did try with Publishing Wizard still no luck.
Now I've realized another interesting thing.
It works fine for reports without Command Objects. Only the reports with command objects are asking for DB password before the Dynamic Prompt.(usnign the same LOV for both reports)