changing logon information

[nithinn]

while calling an existing report i would like to change the logon information for the report ie username and password.
in my jsp page. i tried by by setting the username and pasword in the connectioninfo ibkect and modifying connectioninfo for each database table. but unfortunately it isn't working.
is ther any other procedure to change it?

 

[GPOGA]

Not sure if this will help but it may get you pointed in the right direction.

VBScript:

Set report = InfoStore.Query("Select * from CI_InfoObjects Where SI_Name = 'ReportName' and SI_ProgID = 'CrystalEnterprise.Report'&quot
Set reportInterface = report.Item(1).PlugInterface("&quot
reportInterface.UserName = "Database Username"
reportInterface.Password = "Database Password"

InfoStore.Commit report