You can open the subreport witht the opensubreport() method. This will give you a reference to a report object, which you can use in the same way to set the database location.

Walter,

>Using CR 9 and VFP 7 my application has a number of reports that incorporate a “logoheader.rpt” file as a subreport in the report header band. The idea being that the end users can change the appearance of their logo and company name information simply by editing this “logoheader” report file. All main reports have the “Re-import When Opening” checkbox checked for this header subreport. Unfortunately, the whole scenario fails at customer sites because the location of the embedded subreport is stored as a hard-coded UNC path from my development machine, complete with machine name!
>
>I have code that loops through the
>
>

<report object>.Database.Tables.ConnectionProperties

>
> collection and changes the source data table path names--for essentially the same reason. Surely there must be a public property of the subreport object that stores this physical location path name that can be reset on the fly in the same manner, but, so far, my search through the object model documentation comes up cold. Can you help me out here? BTW, I can’t find it in your book either <g>.