Relocation doesnt work properly

[DenisLagoda]

I have two alike reports. So I did one and made the copy of it. Then I "set location" on another SQL Stored Procedure. In Crystal report it worked properly. But when I used ActiveX element to show report the error happened "...with database DLL..."
Why?
What is wrong?
Thank you in advance.
Denis

 

[techies]

Hi Denis,

What is exact error text?
From what I infer from your question, I think your problem is when you connect to the database.
You have to use
Report.Database.Tables.Item(1).SetLogonInfo(Server,Databse, userid, password)

Then call
Report.Database.Tables.Item(1).Location = "YourStoredProcedure"

Hope this helps, let me know what happens.

cheers,
Techi