Trouble editing reports exported from Spectrum

[tori53]

I'm trying to use reports exported from Spectrum as templates to build new reports with additional info. The downloaded reports open up a new connection (jdbc:sqlserver:...) instead of using the Spectrum connection that I use to create new reports. Neither I or my IT dept have the credentials for the jdbc connection. ( the connections are also listed multiple times and we aren't sure why - maybe that is part of the issue?) Any help would be appreciated!

cr-connections.png

[DonWilliams]

You likely need to contact Spectrum and ask them how to...

[amooney]

Hello,

I am having the same issue. I am able to select Spectrum in my list (it's an ODBC connection) and use the report fields. However, when I try to "Preview", Crystal wants me to connect to JDBC- which I don't have set up and have no information for. Why does it keep trying to connect as a JDBC when I have the ODBC set up and selected?

[former_member11696]

Note the list is under My Connections, it's just listing the connections used in reports you have opened.

Select the Spectrum connection and fill in the log on info and it should work.

Or go down and find JDBC connection and fill in the connection info, you do require the connection info.