This example selects the first report it finds, and examines the EnableNullValue property for the first parameter.
Set IStore = Session("IStore")
Set Result = IStore.Query("SELECT Top 1 SI_PROCESSINFO From CI_INFOOBJECTS Where " & _
"SI_PROGID = 'CrystalEnterprise.Report'")
Response.Write "Example failed: Try logging on first!<BR>"
'Retrieve the first report returned.
Set ReportObject = Result.Item(1)
'Retrieve the report interface.
Set ReportInterface = ReportObject.PluginInterface
Response.Write "Example failed: Try logging on first!<BR>"
If ReportInterface.ReportParameters.Count > 0 Then
If ReportInterface.ReportParameters.Item(1).EnableNullValue = TRUE Then
Response.Write "The user may choose Null for this parameter."
Response.Write "The user may not choose Null for this parameter."
Response.Write "This report does not have any parameters."
Crystal Decisions, Inc. http://www.crystaldecisions.com Support services: http://support.crystaldecisions.com |