How to work with dynamic parameters - LOVs?
I have created some LOVs for my report with the help of Crystal Report in my local system.
I saved this report at a remote site and I can run it in InfoView(Web Server).I am not having access to Business View Manager.
When I run this report there, it asked me to enter database name and password.After this only, I got the input parameter window with the appropriate LOVs field.
I selected the inputs and press OK, again it prompt me for Database and Password entry after that it showed the result.
Those LOVs got added in Dynamic Cascading Prompt under repository items.
Now every time when I tried to run the report before displaying the Input Parameter Window, it is asking me Database Location and password.
I want to schedule it such that it wont ask me again and again about Database and Password.
Please help me to find a solution for it.
Try to open the report in CMC.
Double click the report you can Process Tab.
In process tab go to Data base.
Enable the option use same data base logon as when report is run.-- In Viewing report options.
Update the changes and try to run the report.
I think this would help you.