I am new to Crystal Reports and having some problem in creating a new report. The report is based on a Oracle database and when I include a database call to the report it is asking for a login screen. How can I avoid this?
I have added an SQL Expression Field called Column1 and the sql code is scott.INVENTORY_API.Get_QTY("VIEW1"."C1","VIEW2"."C1")
This report consist of two other views called view1 and view2. When I remove the above call the report runs without asking for a login screen.
Appreciate any feedback on this.