Updating report (made in Crystal Reports) from inside Visual Basic

I have written an addressbook application (in Visual Basic 5), in which Crystal Reports Control is used. Same database (MS Access) is used in the Addressbook and the report. If I edit data in the addressbook application, to update the report I have to come out of the Visual Basic application, and update the report in Crystal Reports.
Can I update the report from inside my Visual Basic application. If so, how?
BhowalAsked:
Who is Participating?
 
DRRYAN3Commented:
In Crystal Reports, on the File menu turn off the option to Save Data with Report.  Save the report (without the data) and try to run your report again.
0
 
profyaCommented:
DRRYAN3 covered a part of the problem, to turn off "Save Data with Report" option. But in many cases you set up your application in a diffrent place than the one you used to dvelop the application. So you may need to dynamically link your application anywhere to it's reports regardless of the location they installed in. Let's say you save your report files in the same folder that contains the application then you need -to dynamically link your application to it's report- to set the following Report control properties:

CrystalReport1.Connect = RPTConnect'Your connect string
CrystalReport1.ReportFileName = App.Path & "\AddressBook.rpt"
CrystalReport1.WindowState = crptMaximized
CrystalReport1.PrintReport


and example for a valid connect string for Access password-protected database is RPTConnect  = ";pwd=MyPassword"
Try it.
0
 
DRRYAN3Commented:
Bhowal - please reject profya's proposed answer (unless it exactly matches your needs).

Profya - I can see that you are fairly new to EE.  In the VB areas, the experts generally do not use the Answer button, but rather the Comment feature to allow as much input from as many people as possible.  When you propose an answer, the question moves out of general circulation.

See the links below for more information on comments and answers.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
profyaCommented:
DRRYAN3,
Yes I'm a new comer in the EE. I'm not gonna block a question once again.
0
 
BhowalAuthor Commented:
Thanks Profya. However,I accept DRRYAN3's comment which solves my problem.
0
 
DRRYAN3Commented:
Glad your problem was solved.  Thanks for the points.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.