For a Crystal report run in BOE to be able to see the file the following things need to happen:
1. Design the report to look for the file in the same location as where it will be located when run from BOE. I haven't worked with XML files as data sources, but you may be able to change the location where the report looks for the file in the CMC after you publish the report to BOE.
2. If the file is in a network location, the BOE services MUST be set up to run under a network user ID that has access to the file location (the default is the local services account on the server where they're installed.) This can be changed in the CCM. We use a dedicated account that has been set up for use by the BOE services only and is set so that the password doesn't expire.
-Dell
A computer only does what you actually told it to do - not what you thought you told it to do.