Loading DataProviders

[skeezwiz]

Hi,

Two DP's in my report DPA & DPB.

DPA comes out of the universe.

I built DPB using VBA which extracts part of the data out of DPA, but whenever I refresh DPB I get the following error.

Run-time error 115 - Error Loading the DataProvider.

Meaning it cant load DPA for some reason?

I used DPA.(load|Activate|Unload) to no avail.

The only way it works if I delete and re-create DPB each time I want to run the report!

Any ideas on why its causing this?

Thanks.

 

[Subhashab]

are using prompt or variable in ur DP

 

[skeezwiz]

2 prompts in DPA

No prompts in DPB.

DPB (VBA) just filters out the data in DPA.

But whenever I refresh DPB, I get an error saying -

Run-time error 115 - Error Loading the DataProvider.

Only time it works is the first time I create DPB, after that I get this error msg.

 

[Sridharan]

Difficult to comment without a glance at your code. If possible, post it. Lemme look into it and see if I can be of help.

Sri