Help with Pervasive SQL in Crystal

[cheerfulskeptic]

I am trying to write a simple report in Crystal 8. It has 2 data sources, however. One is a Pervasive SQL Database and one is a SQL Server database.
I am using 3 tables

From SQL Server
proctime
accounts

From Pervasive
Customer Main

where the accounts.accountid = proctime.parentid (one to many)
and
accounts.MAXID = Customer Main.CUSTID
(they are both same datatype of Char(7))

I am trying to have a grouping by accounts.accountid and display the proctime.procdate, etc. fields in the detail section. I also want to display the Customer Main.CUSTID from PErvasive field next the accountid.

However, crystal crashes (End Program, unstable, etc.).

what is the solution? Can we not do this? Is this because the SQL Server sql is different from PErvasive sql?
Please help!
THanks in advance!
- Ambar

 

[cheerfulskeptic]

I forgot to add, the error only comes when I add a formula or running total (count of the field proctime.proctimeid).
The error does not show when I remove the form/running total from not only the report design, but from the formula selector box.