Crystal 9/ASP/XML Changing Data Source

[domosullivan]

Hi - I have created a report based on an ODBC XML data source. I want to be able to change this data source at runtime (on an ASP page) such that I can view different XML documents through the report.
Essentially the Crystal KB suggests the following line should do the trick.....

session("oRpt&quot.Database.Tables.Item(1).Location = "DocNew.xml"

....Assuming that the DocNew.XML is in the same location as the original document the report is based on.

I cannot get this to work, I have tried providing a full path to the document but still not luck.
Am I missing some other steps?
Any help most appreciated.
Thanks.

 

[ajdesigns]

try going to database set location, from the dropdown pick the source you want, when promted to set same location for other tables click yes.