Saving parameters to a report

You do not need to save any changes to a report's parameters before you view it with those parameters. Saving changes could cause problems if multiple users are viewing the same report. On occasion, however, you will need to save changes to the report. Following the example below, once you have made any changes to the Report object, save them by using InfoStore.Commit.

Example

Set Result = InfoStore.Query("Select TOP 1* From CI_INFOOBJECTS Where" & _

    "SI_PROGID = 'CrystalEnterprise.Report' AND SI_NAME='myReport.rpt'")

Set ReportObject = Result.Item(1).PluginInterface

Param1 = ReportObject.ReportParameters.Item(1).ParameterName

'Modify parameters here

'...

'Save changes

InfoStore.Commit Result