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

    Question 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.
    Good Question?

    Featured Post

    Course: Foundations of Front-End Development

    Jump-start a lucrative career in front-end web development, with zero previous coding experience required. This course covers the basic programming concepts and languages required for creating engaging websites from scratch.

    Top Expert Contributor

    Essential articles and videos from the Experts

    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Want to make your posted content more private? Follow these quick and easy steps to change the display name associated with your posted content.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

    More valuable questions with Expert answers

    Question: I'm trying to display some data in a graph format for a report. The vertical axis has a $ value the horizontal access lists dates. The report is showing the value of shipments by date for the current month and is meant to be sent daily to sales...

    Answer: One option is to add a Dates table to your database with one record for each date. Then, do an outer join to your transactions data and group by the Dates.Date column.

    Question: A client running one of my VFP9 SP2 apps on Windows 7 workstations recently installed a batch of security updates to his Windows 2008 R2 server, and the VFP apps stopped working. The programs, which are stored on the server along with the data,...

    Answer: I don't have such problems because I am not executing VFP apps over the network. The network traffic reduction is the first rule applied to effective application run. Also VFP is very sensitive to network connection dropouts so the local app can...

    Question: I have some field that contain the date but shown as date and time as 00:00:00 and another fied that has the date as 1900,01,01 and the correct time I would like to do a comparison fod the requested date/time and the completion date/time But the...

    Answer: To get the difference in hours you need to use DATEDIFF Try it this way (CODE) mlmcc

    Question: I'm having trouble coming up with a formula to clean the record result "kriegel 06/13/2016" to show the date only, as "06/13/2016". Right now, I have a formula that is taking out the alphas, but also the "/". Beside being just a mess of numbers...

    Answer: Sure. Simply start the formula with local stringvar StartString := {part.user_8} ; The logic already takes care of both upper and lower cases.


    Extend your technology team with the Experts Exchange community.

    — trusted by —

    Who answers my questions?Our community has technology experts around the world.



















    RELATED TOPICS view all topics

    1. DB Reporting Tools
    2. .NET Programming
    3. Visual Basic.NET
    4. ASP.NET
    5. Visual Basic Classic
    6. MS SQL Server
    7. MS SQL Server 2005
    8. Databases-Other
    9. C#
    10. Oracle Database