Where Subreport Files are stored

[mgpeters]

Platform: CE/CR 10, Oracle db, direct connect

I have a large report with numerous subreports. I store a copy of these subreports in a directory and update this copy anytime a change is made.

I am now making a new "version" of this report which points to a different instance of the database. I created a 2nd subdirectory to hold all of the subfolders for this instance. (the only difference between the sr's is the datasource)

In the new version of the main report I changed the data source using Set Datasource Location. I then saved each of the subreports to the second subdirectory.

However, when I re-import a sub-report it pulls it from the ORIGINAL subdirectory. I confirmed this by renaming one of the sub's in the original directory and then tried re-importing the subreport in to the revised report and I got a message that it could not find the subreport it was looking for and at that point it gave me the full path/filename that it was looking for.

Having said all that...
1) Is there a was to tell what file a subreport is pointing to?
2) How can this be changed? Does it have to be done one at a time or is there an easier way?

Thanks for the help,
Mark

 

[MrBillSC]

I believe you will need to change the data source of the subreports to the "different instance of the database" as you did with the main report.
I don't know why your main report can't locate the subreport, but you can always delete and re-add and link the subreport.

MrBill

 

[mgpeters]

While in the main report, when I did the "Set Datasource Location" I did change the data source of both the main report and the subreports. I then saved each of the subreports to the 2nd subdirectory. However, when I re-import a subreport it pulls it from the original subdirectory (where the subreports pointing to the old instance are located)

 

[MrBillSC]

Instead of reimporting, try deleting and re-inserting the subreport selecting the subreport from the 2nd subdirectory.

MrBill

 

[mgpeters]

Another workaround that seems like less effort is to temporarily re-name the original subdirectory and then attempt to re-import, I am then asked to browse for the subreport and at that time go to the 2nd subdirectory.

The benefit of this over deleting and re-inserting the subreports is that the location, size and formatting of the sub-reports is maintained by this method.

I was just hoping someone would know of a cleaner, easier way to do it.