asked on

Crystal Reports ActiveX Control

I am running VB6.0 and the latest Crystal Reports ActiveX control for VB5.0/6.0 on a Win98 machine.

I have an Access Database for the datasource and a table in the designer is made up of a query. However, when the database changes and I have to "Verify" the database to make it work correctly, I have to move my database to the location that the designer points to. How do I change the file that the designer points to?

So, my datasource is "bound" to: "C:\MyFolder\MyDatabase.mdb" but I want it "bound" to: "C:\MyOtherFolder\MyDatabase.mdb"

Any idea how?

Egore

ASKER

Do I have to delete the datasource, create a new one datasource and then link all of the controls on the ActiveX control to the new datasource, or is there an easier way?

BeedleGuis

can'r you just alter the dsn?

ASKER CERTIFIED SOLUTION

peterdc

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jason_lewis

If you are using their ActiveX (where you actually have a small hidden icon on your form and you set the Action = 1), you can create a 'bound report' that will look at a data control on your form. Then, you can change the database, refresh, even query the database to return only the specific records you need -- All from VB code. Let me know if that sounds like what you want to do. I'll post more info.

--J

PS -- If you are using this (old) control, check out the Seagate website. They have a new ActiveX Designer that actually integrates with the VB IDE. It builds reports directly into your project. It's a little harder to use, but it sure gives you a lot more control over the data. (And best of all, it's completely FREE to users of the old control -- at least it was two months ago when I grabbed it.)

Egore

ASKER

Thanks! I just had to make a minor adjustment to what you said and it works like a charm!