I have created a crystal report that contains 3 subreports. Each one of the sub-reports access a different database server. The 3 sub-reports use the same user name and password to access the db server. When I set up the action to run the report with the 3 subreports, I get an error of logon failed. I have verified that the credentials specified on the configuration screen are correct. What I think the issue is, is the fact that this report uses 3 sub-reports and even though the account is the same, logicity software does not handle this type of scenarios.

Could I be right? If not, would I be able to get insight on how to approach to this scenario and successfully run/ email this report?

For your help, many thanks in advance.

anavagomez.

Hello!
We do not currently have a way to provide credential for more than one database with Logicity, but it is on our list to add to future updates.
Currently, the only workaround is to use a database connection methodology that doesn't require authentication(i.e. File DNS, Active Directory Authentication, etc.)
I hope this helps!
-Devin

Devin,

When do you think you will support multiple databases

Realistically we are probably at least a year out from supporting that. We have determined that the software needs to be entirely re-written in order to support that due to limitations of the RRD schema. To complicate matters further, we have a lot of users that rely on the RRD format remaining unchanged so we are walking a fine line on adding a feature versus causing troubles for existing users.

Thanks for your reply. Would it be possible to have a tick box option so it could be one or the other.

In other words for the traditional RRD leave the box blank.
For multiple databases tick the box and populate the information

The problem is that we need a mapping that defines the credentials for each connection. A report might have 5 different database connections on it and each may require different credentials, so we need layout that is going to read in all of the connections and allow you to provide info for each. In our conversations internally how to keep existing users happy (who have invested in the RRD format remaining unchanged) while adding this new feature we are essentially going to try to support both formats but in order to do multi-database you'd be required to use the new format.