HOWTO: Prevent the Report From Displaying When the Parameters Dialog is Cancelled Using Script

KnowledgeBase for ActiveReports

HOWTO: Prevent the Report From Displaying When the Parameters Dialog is Cancelled Using Script

09-30-2005, 6:54 PM
Script can be used to prevent any report from displaying in the viewer if they click Cancel on the parameter dialog window. Use the following code:
Sub OnPromptDialogClosed(Cancelled)
    If Cancelled = True Then
        rpt.Cancel
        Exit Sub
    End If
End Sub