Hello,
The current version (unfortunately) only supports a single data source for the entire Crystal Report so if you are using one connection on your main report and another for your subreport you will get that second prompt. If you thinking you are using the same data source for both sections of the report, try doing a Set Location on the main report connection, all of the tables, the subreport connection, and all of it's tables. If you do need both connections, the only workaround that works for some folks is to try to find a way to connect to the database without providing credentials. For example:
- With SQL Server, use Active Directory authentication to the server.
- If you are connecting via ODBC, try using a File DSN where you can specify the password in the DSN (you usually need to edit the .DSN file to do this).
Hope this helps but it may just be a limitation with Logicity,
Adam