How to avoid Username/password prompting twice for the same report ?

[jpdmdc]

Hi all,

I'm using Crystal reports 10 on Oracle 9i database! I have a report with a sub report in it. The main report runs on a procedure whhile the sub report runs on tables. Both the reports run on the same database. But the Username/password is being prompted twice! I want it to prompt only once because main as well as the sub reports run on the same database.

Please help!

Thank you!

 

[almir]

If your tables in report have two different levels of protection, i.e. different passwords, try to enter higher-level password first.