Dynamic LOV using Oracle ODBC connection on Crystal XIR2

building reports crystal reports
1

Hi,
I have created Crystal Report with dynamic prompt based on oracle ODBC
connection. I deployed this report on BO server and it asks me to enter
username and password even though I have configured its connection on BO sever. When I delete this dynamic prompt or make it static prompt its working fine on BO server via Infoview. Even when I run this report on local machine using dynamic prompt its wroking fine.
So how to create dynamic prompt or what causing this problem?

Thanks in advance.

wack_jack (BOB member since 2005-12-28)

2

Did you create the dynamic prompt in BusinessView Manager?

There is a setting in the LOV in BVM that defaults to ‘Always Prompt’ but can be changed to ‘Never Prompt’.

Sounds like that could be the issue.

Dawn :idea:

djp (BOB member since 2007-04-11)