How to publish reports and subreports on CR Enterprise

[vatawna]

Hi,

I'm using CR9. I'm trying to make a report and subreport work properly on CR Enterprise 9. The problem I'm having is, after the reports have been published, if I click on the main report's link field to get to the subreport, I get an error message: "Cannot retrieve the data in on-demand subreport."

I don't have this problem on my local machine. I also checked the datasource location, the subreport location, the subreport link where my main report points to, etc., and still can't find anything that could cause this error.

Does anyone know how to fix this?

Thanks.

 

[synapsevampire]

Since you didn't mention the type of database used, I'll assume that it's a MS Access or some other file based database, and the path is different than on the CE Server.

You should be pathing using UNC pathing (\\machine\path...) as opposed to drive letters.

Impossible to know though since you were a bit shy about fleshing out your environment.

-k

 

[vatawna]

Hi synapsevampire,

Thanks for responding. I'm using MS Access. I did convert the datasource location to UNC path. It didn't work.

Thanks.