THIS MONTH ONLY

25% OFF YOUR FIRST YEAR

Use code: FIRSTYEAR25

Welcome to the #1 Community for Technology Professionals.

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

Asked by: ContrAcctSolved by:
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.
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

Comments
9

This solution is premium contentAccess this technology solution plus 4 million more as a premium member.

Become a Premium Member

  • Solve problems faster with premium solutions and 1-on-1 expert help
  • Advance your technical skills with access to training resources
  • Grow your career by networking with industry thought leaders

Try it Free

30 day free trial. Cancel anytime.

Experts Exchange is trusted by 44 of the top 50 Fortune 500 companies.

How It Works

Put the power of 100,000 technical experts to work for you. Whether you're stuck with a difficult problem, need to expand you skills, or want to network with others in your technical area, our global expert community will help you get your job done and become a better professional.

Michael Victors Independent IT Consultant California, USA

Jon McAdams Network Manager B.C., Canada

Chris Habina System Engineer London, England

Greg Reynolds IT Manager Texas, USA

Hear from Our Community

"Three years back we had a client requirement for developing an asset tracking solution that required data acquisition from different data sources. I was assigned the role of DBA. With no practical experience in database administration, I was clueless on how to proceed. Thanks to the guidance and support of Experts Exchange's vast talent pool, I was able to complete the data integration process in less than a week's time, which saved our company more than $2000 worth of man-hours and got me a promotion!"

Sherkar Bhurshan

RFID Consultant at Aplomb Global IT Consultants

"My Staff and I use EE on a daily bases to solve all kinds of issues. One answer can be worth the cost of a lifetime membership! For example, we ran into a bunch of problems when migrating our Exchange environment from 2003 to 2010. We kept running into issues and repeatedly the best and most detailed info was coming from Experts Exchange. One of the last issues was getting active sync and OWA published correctly and the partners we were using were struggling for hours. Finally I decided to go look for my own answers and was able to find what was looking for on Experts Exchange. It was a life saver!"

Jakub Hanson

Director of Infrastructure at Noel Group LLC

"A few years back, I worked for a British bank in compliance. When the bank sold its trading department to an American company, the compliance systems had to change rapidly to avoid managers being charged with not submitting compliance reports to the government, which would have been a criminal offence. Experts Exchange helped me get the job done on time."

Murray Brown

Programmer at Murbro Ltd

201401-VQP-099

Experts Exchange powers the
growth and success of technology
professionals worldwide.

Try it Free

30 day free trial. Cancel anytime.

Learn More about How It Works

Get Experts Exchange's

Career Builder Guide

Become successful in your tech career.

We will never share this with anyone.

Experts Exchange is the Network for
Technology Professionals

  • An essential resource for producing excellent work

    Experts Exchange is the tech professional’s trusted, on-demand resource for solving difficult problems, making informed decisions, and delivering excellent solutions.

  • A better way to learn technology

    With unparalleled access to technical experts, verified real-world solutions, and diverse educational content, Experts Exchange enables personalized development of technology skills.

  • The network for building your tech career

    Experts Exchange gives you the professional exposure and valued relationships key to building the career you want.

Experts Exchange powers the growth and
success of technology professionals worldwide.

Try it Free

30 day free trial. Cancel anytime.