Link to home
Start Free TrialLog in
Avatar of RUA Volunteer2?
RUA Volunteer2?Flag for United States of America

asked on

Crystal Reports Points to an Microsoft Access Database Accdb reports fail when we split the DB from the VB code

We have several reports that were created to run off a Microsoft Access Database. They were all working fine up until we decided that we needed to separate the code from the database as users of the Access system would go into the application we designed and would inadvertently get a debug process started and before you know it they would have changed a line of code. So we broke the VB and DB up.
We noticed the following anomalies:

1. We immediately got an invalid Argument when we "Set Data Source Location" to the new database. So we took the old DB and mapped to the new DB file. This did not work until we changed one of the groups inside of the report. {OfficeUse.Code} All we did was go to Change Group and scroll through the list and pick the second duplicated field group {OfficeUse.Code}. That particular report has the group {OfficeUse.Code} that is duplicated once in Group Header 1 and Group Header 4.

2. Next once we got the data to connect. We noticed that the records were replicating exponentially. It did not make sense that we were getting duplicates when all the links were the same.

3. Finally we ran the report for ALL {OfficeUse.Code} 's and all records are returned. When we select one specific code for {OfficeUse.Code} which shows up in the records hundreds of times when ALL is selected,we get NO RECORDS RETURNED for that single code........this makes no sense to us...? One other thing here is that we also loose the logo for the report for this. It is almost as if every time we run for one specific {OfficeUse.Code} we loose connection with everything.

Has anyone ever experienced these anomalies before or know what causes them. We are going to have to update many reports and wondered if this will be a recurring theme.

We did try another report and set the data source location and it worked. So it may be the duplicated {OfficeUse.Code} group. Any knowledge might be helpful.
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RUA Volunteer2?

ASKER

Thank you guys. Mike one of these days. I will have to buy you dinner.