Pervasive and Crystal Reports 1

[groasa]

We are about to deploy to a few beta sites to upgrade our software to use Crystal Reports 8.5 on Pervasive.SQL 2000i database. (Connecting through ODBC)

There is a table that contains invoice history which may hold anywhere from 2 months to 2 years of data depending on the customer. On previous Btrieve databases, they created an executable that would create a temporary table to access this data to speed up performance.

Does anyone have any ideas on how to access this data without using the "workaround"? I've tried creating simple views, dabbled a little with the Crystal SQL designer, but it still takes a long time to run. HELP!

 

[Maximizer]

Personally, I have had greater performance with Crystal Reports 8.5 utilizing Pervasive.SQL 2000i recently. The latest “Btrieve” service patch ‘3' added much needed improvement for creating SQL statements among other items. The access speed has significantly increased (ie read feels more like 32-bit).

Perhaps test some SQL statements via the Pervasive Control Center. Using the PCC directly, has assisted me in bettering my reports.

Good Luck! James Keep, A.C.E.
Crystal Reports(tm) Certified Consultant
CMRC
Crystal Decisions Business Partner
Montreal, Qc, Canada

http://www.cmrc.qc.ca