Solved

Find crystal connection string

Posted on 2006-11-16
5
736 Views
Last Modified: 2008-02-26
Hi All,

I am a total crystal reports newbie who is working with crystal reports 10. How do I find the connection string that a pre-existing report is using?

Thanks in Advance.
0
Comment
Question by:lunch_is_4_wimps
  • 3
5 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
What are you trying to do?

As far as I know there is no way in Crystal to retrieve the string.

You could open the report file in Word or other test editor and simply scroll through until you find it.

mlmcc
0
 
LVL 13

Expert Comment

by:EwaldL
Comment Utility
Do you want the SELECT statement? Or do you want the connection string that is used to connect to the db  in the first place, if so, what would you need it for?
0
 

Author Comment

by:lunch_is_4_wimps
Comment Utility
I was trying to find the connection string to connect to the db. One of our sites was disconnecting from the db when we ran crystal reports, I was trying to debug the possible cause of the problem be seeing the connection string that crystal was using.
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
Comment Utility
When I opened a report in MS Word I was able to see the connection string.  There may be a way to get at it programmaticly but I don't know how.

You might check the report documentors at
http://www.kenhamady.com/bookmarks.html

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Glad i could help

mlmcc
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now