Help needed with sub reports with error messages

[shortstuff2212]

I have a report which has two subreports in it and it was designed using an odbc connection to an ~Access 97 db. The data source name is VMLive and the db name is db1.mdb. If I run it through a VB programe I get the following error message.

20515 Error in formula <Record_Selection> '{CandidateArea.CandArea_Name} = 'ALEXANDRA' AND {Candidate.Cand_ElectionID} = 18' This field name is not known.

Both these tables and fields are used in the report. When I run the same report through a VB program which has an odbc data source name of QNFLive and db name of db1.mdb I get the following error

20515 Error in formula <Record_Selection> '{Subscribers.Candidate_id} = {?Pm.Subscribers.Candidate_Id} and ' This field name is not known.

Again these are fields that are used in the report.

Can anyone help with this I am very confused!!!!

Thanks in advance

 

[kenhamady]

Do you have commands that log the report and subreport into the DSN? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[shortstuff2212]

No, I don't know how to do that.

 

[kenhamady]

Not sure which integration method you are using but look at the commands:

Connect
LogOnServer
SetLogonInfo Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com