"Set Location" change on the fly...

[JScannell]

Has anyone ever used the web interface of CR 8.0 and changed the database table to use at the time of execution? If so, please show me the code. I can't seem to get it right.

Jerry Scannell
JScannell1@Home

 

[mmaz]

Hi! I'm calling reports from ASP, and I used the SetLogonInfo method and the Location property to change table at runtime. I got the following sample code from Seagate's support web site at

http://support.seagatesoftware.com:

'pass the physical server name, database, user ID and password to the SetLogonInfo method.
'SetLogonInfo can be used to connect to the existing server or a new server
Report.Database.Tables.Item(1).SetLogOnInfo "Server2", "master", "admin ", "admin"

'The location property sets the new database owner and table name.
Report.Database.Tables.Item(1).Location = "master.dbo.authors2"

Hope this helps!!