Duplicating Database Connections

[Former Member]

One of my end users is having issues with duplicate databases being made in addition to needing to log in every time a report is refreshed. All their reports are supposed to be under one connection so I am not sure why this is happening.

Is there a way to fix this?

[Former Member]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html

Questions on how to draw responses from members? Check out this discussion on how to improve questions. https://groups.community.sap.com/t5/welcome-corner-discussions/advice-from-sap-champions-questions-a...

[DellSC]

This should only happen if the user is creating a new connection each time they log in. The user should refresh the report and a login screen will appear (Crystal does NOT save passwords, so this is how it works!). Instead of creating a new connection, they should use the existing connection and just log in to it.

-Dell

[JohnClark]

As far as I know this would appear to be normal behavior. Anytime you open a report that uses a connection of the same name, it can create a new connection under the My Connections. I think of that area as more of a "recently used connections" list. If they are selecting a connection there, they just need to always select the same one.

[ffgit]

Hi John -

Thank you for responding! I know next to nothing about this software, and it has only become an issue since an end user who normally uses it is leaving the organization. They brought this concern to me, and the original user I guess did not have that problem. Is there a way to disable/remove this? I can see this becoming a problem down the road where there's a hundered of them.

[JohnClark]

ffgit , any connection that is listed under My Connections can be deleted. Just right click on it and select delete.