Script Editor
To access the script editor, click the script tab below the report design surface. The script tab contains two drop-downs (Object and Event).
- Object: Drop down the list and select one of the report sections, or the report itself.
- Event: Drop down the list and select from the list of events generated based on your selection in the Object drop down. If you select a report section as the Object, there are three events: Format, BeforePrint, and AfterPrint. If you select ActiveReport as the Object, there are seven events. See Section Report Events for further information.
Add script to the events in the same way that you add code to events in the code view of the report. When you select an event, the script editor generates a method stub for the event.
Using the ScriptLanguage property of the report, you can set the script language that you want to use.
Select the scripting language to use
- In design view of the report, click in the grey area below the report to select it.
- In the Properties window, drop down the ScriptLanguage property and select C# or VB.NET.
You can also add scripts at runtime using the Script property.
 |
Caution: Since the RPX file can be read with any text editor, use the AddCode or AddNamedItem method to add secure information such as a connection string. |
Tips for Using Script
- Keep the section report class public: If the Section Report class is private, the script cannot recognize the items in your report. The Section Report class is public by default.
- Set the Modifiers property of any control referenced in script to Public: If the control's Modifiers property is not set to Public, the control cannot be referenced in script and an error occurs when the report is run. The Modifiers property has a default value of Private, so you must set this property in the designer.
-
Use "this" (as in C# code-behind) or "Me" (as in VB code-behind) to reference the report. Using "rpt" to reference the report is also possible but it is recommended to use the "this" and "Me" keywords.
Note: The basic approach of using the "this/Me" and "rpt" keywords is as follows - use "this/Me" to access the properties and controls added to the sections of the report, whereas use "rpt" within the instance of the ActiveReports class only to access its public properties, public events and public methods. - Use Intellisense support: The script tab supports IntelliSense that helps in inserting the language elements and provides other helpful options when adding script to a report.
- Use Run-time error handling: When run-time errors occur, a corresponding error message is displayed in the Preview tab stating the problem.
Difference in script and code-behind event handler
Code-behind and the script tab require a different syntax for the event handler method definition. Use the Private modifier in code-behind and the Public modifier in the script editor.
See the following examples of the ReportStart event handler definition in Visual Basic and C#:
Script and code-behind examples in Visual Basic
The ReportStart event handler definition in the script editor:
Visual Basic.NET |
 Copy Code |
|---|---|
Sub ActiveReport_ReportStart End Sub |
|
The ReportStart event handler definition in code-behind:
Visual Basic.NET |
Copy Code |
|---|---|
Private Sub SectionReport1_ReportStart(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.ReportStart End Sub |
|
Script and code-behind examples in C#
The ReportStart event handler definition in the script editor:
CS |
Copy Code |
|---|---|
public void ActiveReport_ReportStart() { } |
|
The ReportStart event handler definition in code-behind:
CS |
Copy Code |
|---|---|
private void SectionReport1_ReportStart(object sender, EventArgs e) { } |
|