Skip to Content
author's profile photo Former Member
Former Member

Crystal Reports XI and Sage Pro ERP / VFP database

I am a little hesitant to post here as I am somewhat a rookie with this, but I am looking for some guidance on utilizing CR with a VFP back end databse with a ACCPAC Sage Pro ERP system.

The ERP system uses a current and history table for say sales order transactions and I am having a difficult time querying the data from both of these table when the table structure is exactly the same.

Any guidance of hint would be more than appreciated. I have built a great little open order report because it doesn ot need to query the histroy file, but anytime I need both current and history information, say comparative sales information on a customer, I am dead.


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2009 at 09:17 PM


    I think you'll find more assistance with your post your same question to the Crystal Reports Design - [SAP Crystal Reports;. This category your in is for Business Objects Enterprise related questions. I hope that helps you.


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.