Question

Crystal Reports Viewer ActiveX Control in Visual FoxPro 9 Keeping Foxpro Tables Open

Asked by: ContrAcct
We have a form in our software package that runs the Crystal Reports Viewer 9.2 ActiveX control written in Visual FoxPro 9 SP2. The crystal reports we use have been written to read our VFP table data through ODBC. The crystal reports viewer works well, as I've used Experts' Exchange several times to get that piece to operate.

However, we have several features in our software that requre large and secure transaction processing, therefore we sometime need exclusive use of specific tables in our database. Since our application is typically shared over a network by many users, one user might have the crystal report viewer open with a report that uses a table which another user needs to use exclusively.

My question is: can the crystal reports viewer (or perhaps the crystal reports themselves) be written to close the VFP tables it uses once the report has been run without having to completely close the form containing the crystal report viewer?

I have tried to read the DownloadFinished property of the ActiveX control, but that has never returned true. Perhaps there is another property I can read, or a method I can run to close the VFP tables or data connection without having to close the resulting report.

FYI - These same reports, when run with the full Crystal Reports 2008 also leaves the VFP tables open without being able to get exclusive use.

This question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

  • Plus...
  • 30 Day FREE access, no risk, no obligation
  • Collaborate with the world's top tech experts
  • Unlimited access to our exclusive solution database
  • Never be left without tech help again

Subscribe Now

Sign Up Now!
Asked On
2011-04-05 at 09:30:59ID: 26935060
Tags

Microsoft Visual FoxPro 9

,

Crystal Reports Viewer

,

Open Tables

Topics

Crystal Reports Software

,

FoxPro Database

Participating Experts
3
Points
500
Comments
9

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

Companies like CVS, Honeywell, Chevron, Toyoto, TriStar Pictures, the U.S. Army, and Accenture

Your Complete Technology Resource

900+ topic areas (and counting)

Related Solutions

  1. VFP & CRYSTAL REPORTS
    I have developed an application using vfp. But I want all the reports in Crystal Reports. Is it advisable to use Crystal Reports with VFP?
  2. Calling a Crystal Report from Foxpro
    Is it possible to call a crystal report from inside Foxpro. If so what would the code be?
  3. Crystal from foxpro
    I'm sure this has been beat to death, but my problem still exists VFP6.0 form has a command which calls a VFP program that creates a file then prints a Crystal 8.5 report (unrelated to that file)Crystal prompts me for my report date par...
  4. FoxPro 8 and Crystal Reports 9 Releasing of CR…
    Hello, I am using VFP 8.0 SP1, CR 9 Advanced, and MS-SQL 2000 SP3 (for the database). I am having this difficulty. I am trying to make a report to print individual customer information sheets. I get the data from the SQL server, and...
  5. Crystal Reports for a FoxPro database
    Hello, I'm in a debate with a co-worker whether Crystal Reports would be compatible with a FoxPro database, containing Head Start program data. To me, I thought that CR would just need to connect to the database and then it's just a ma...
  6. Access VFP 9 tables with Crystal Reports
    I am trying to create crystal reports from Visual Foxpro 9 tables on an XP Pro laptop. When I attempt to setup the ODBC driver I get an error message stating that I need to install the latest version of the VFP ODBC driver and it direc...
Tutorials are great ways to tackle hard problems!

Featured Articles

Read through articles written by top experts!

Get full access to the help you need.

Subscribe Now

30-day free trial. Register in 60 seconds.

The Latest Technology News and Tips

Your answer is only minutes away!

New Solutions Everyday

Because of our active community of experts, on average new questions receive their first comment in under 30 minutes.

Top Crystal Reports Questions

       

Hear What our Users are Saying

Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.

Subscribe Now

30-day free trial. Register in 60 seconds.

20130221-EE-VQP-038

3 Ways to Join

30-Day Free Trial

The Experts

98% positive feedback on 31,087 answers since March 2000. angeliii is a Microsoft Most Valuable Professional for his work with MS SQL Server & Development.

He has also proven his knowledge of Visual Basic Programming, PHP Scripting and Oracle Databases.

The Experts

97% positive feedback on 10,752 answers since July 2000. lrmoore has more than 18 years experience in the networking industry.

The six-time Microsoft MVPs specialties include firewalls, virtual private networking, and network management.

Testimonials

"...an excellent source for support... Kind of like having your very own IT dept." Electriciansnet

Testimonials

"I was apprehensive at signing up at first. However... it has already made my life as an IT administrator much easier." JaCrews

Testimonials

"WOW! You guys have great, active, and knowledgeable people on here." moore50

Business Clients

Business Clients

In the Press

"If you’ve got a question... Experts Exchange can supply an answer.”

In the Press

"...an invaluable aid for both IT professionals and those who require tech support."

In the Press

"where IT professionals provide quick answers on just about any topic"

Business Account Plans