To add script to a report to access a textbox named TextBox1 in the detail section and assign the text "Hello" to it:

1. On the script tab of the report, drop down the Object list and select Detail. This populates the Event drop-down list with section events.
2. Drop down the Event list and select Format. This creates script stubs for the event.

   To access a textbox in the detail section in VB.NET script

   Visual Basic.NET script. Paste INSIDE the Detail Format event.	Copy Code
   Me.TextBox1.Text = "Hello"

   Or

   Visual Basic.NET script. Paste INSIDE the Detail Format event.	Copy Code
   CType(rpt.Sections("Detail1").Controls("TextBox1"), TextBox).Text = "Hello"

   To access a textbox in the detail section in C# script

   C# script. Paste INSIDE the Detail Format event.	Copy Code
   this.textBox1.Text = "Hello";

   Or

   C# script. Paste INSIDE the Detail Format event.	Copy Code
   ((TextBox)rpt.Sections["detail"].Controls["TextBox1"]).Text = "Hello";

Using the AddNamedItem method, you can allow the script to access functions in a class file within your project. This allows you to keep secure information such as a database connection string or a SQL query string in the code instead of saving it in the RPX file.

1. In the Code View of the Form, add a class to your project named clsMyItem.

   To add a class in Visual Basic.NET

   Visual Basic.NET code.	Copy Code
   Public Class clsMyItem End Class

   To add a class in C#

   C# code.	Copy Code
   public partial class clsMyItem { }

2. Add a public function to your class using code like the following:

   To create a public function in Visual Basic.NET

   Visual Basic.NET code. Paste INSIDE the new class.	Copy Code
   Public Function getMyItem() As String getMyItem = "Hello" End Function

   To create a public function in C#

   C# code. Paste INSIDE the new class.	Copy Code
   public string getMyItem() { return "Hello"; }

3. Go to the design view of the report and double-click the gray area around the design surface to create an event-handling method for the ReportStart event.
4. Add the following code to the handler:

   To access the class in Visual Basic.NET

   Visual Basic.NET code. Paste before or in the ReportStart event.	Copy Code
   Me.AddNamedItem("myItem", new clsMyItem())

   To access the class in C#

   C# code. Paste before or in the ReportStart event.	Copy Code
   this.AddNamedItem("myItem", new clsMyItem());

5. From the Visual Studio toolbox, drag and drop a TextBox control onto the detail section of the report.
6. Go to the script tab and drop down the Object list to select Detail. This populates the Event drop-down list with section events.
7. Drop down the Event list and select Format. This creates script stubs for the event.
8. Add the following script to the event to access a control on the report and populate it using the named item.

   To access the control in VB.NET script

   VB.NET script. Paste INSIDE the Detail Format event.	Copy Code
   Me.TextBox1.Text = myItem.getMyItem()

   Or

   VB.NET script. Paste INSIDE the Detail Format event.	Copy Code
   CType(rpt.Sections("Detail1").Controls("TextBox1"), TextBox).Text = myItem.getMyItem()

   To access the control in C# script

   C# script. Paste INSIDE the Detail Format event.	Copy Code
   this.textBox1.Text = myItem.getMyItem();

   Or

   C# script. Paste INSIDE the Detail Format event.	Copy Code
   ((TextBox)rpt.Sections["detail"].Controls["textBox1"]).Text = myItem.getMyItem();

9. Go to the preview tab to view the result.

Using the AddScriptReference method, you can gain access to .NET or other namespaces. This is only necessary if you need a reference, such as System.Data.dll, that is not initialized in the project before the script runs.

To access a namespace in Visual Basic.NET

Private Sub runReport() 
      Dim rpt as new YourReportName 
      rpt.AddScriptReference("System.Data.dll") 
      rpt.Run() 
End Sub

To access a namespace in C#

private void runReport() 
{ 
      YourReportName rpt = new YourReportName; 
      rpt.AddScriptReference("System.Data.dll"); 
      rpt.Run(); 
}

Using the AddCode method in the Code View of the Form, you can add code into the script. The AddCode method allows you to add actual code segments to the script at run time. This is useful for allowing secure information, such as a database connection string or SQL query string, to be used inside the script without saving it in the RPX file.

1. Go to the Code View of your report and add a public function like the following:

   To add code in Visual Basic.NET

   Visual Basic.NET code. Paste INSIDE the report class.	Copy Code
   Public Function addThisCode() As String Dim sCode As String = "Public Function ShowACMessage() As String" + Environment.NewLine + "ShowACMessage = ""my Added Code""" + Environment.NewLine + "End Function" addThisCode = sCode End Function

   To add code in C#

   C# code. Paste INSIDE the report class.	Copy Code
   public string addThisCode() { string sCode = "public string ShowACMessage(){return \"my Added Code\";}"; return sCode; }

2. In the design view of your report double-click the gray area around the design surface to create an event-handling method for the ReportStart event.
3. Add the following code to the handler:

   To access the class in Visual Basic.NET

   Visual Basic.NET code. Paste INSIDE the ReportStart event.	Copy Code
   Me.AddCode(addThisCode())

   To access the class in C#

   C# code. Paste INSIDE the ReportStart event.	Copy Code
   this.AddCode(addThisCode());

4. Go to the script tab and drop down the Object list to select Detail. This populates the Event drop-down list with section events.
5. Drop down the Event list and select Format. This creates script stubs for the event.
6. Add the following script to the event:

   To write the script in Visual Basic.NET

   VB.NET script. Paste INSIDE the Detail1_Format event.	Copy Code
   Me.TextBox1.Text = ShowACMessage()

   Or

   VB.NET script. Paste INSIDE the Detail1_Format event.	Copy Code
   CType(rpt.Sections("Detail1").Controls("TextBox1"), TextBox).Text = ShowACMessage()

   To write the script in C#

   C# script. Paste INSIDE the detail_Format event.	Copy Code
   this.textBox1.Text = ShowACMessage();

   Or

   C# script. Paste INSIDE the detail_Format event.	Copy Code
   ((TextBox)rpt.Sections["detail"].Controls["textBox1"]).Text = ShowACMessage();

If the script requires a method to be called, you can construct a class inside the script.

1. Go to the script tab and add the following code at the top:

   To create a class inside the script in VB.NET script

   VB.NET script. Paste INSIDE the script tab.	Copy Code
   Public Class MyFuncs Public Sub New() End Sub Public Function ShowMyString() As String Return "This is my string" End Function End Class

   To create a class inside the script in C#

   C# script. Paste INSIDE the script tab.	Copy Code
   public class MyFuncs { public MyFuncs() { } public string ShowMyString() { return "This is my string"; } }

2. On the script tab, now drop down the Object list and select Detail. This populates the Event drop-down list with section events.
3. Drop down the Event list and select Format. This creates script stubs for the event.
4. Add the following script to the event:

   To create a class inside the script in VB.NET script

   VB.NET script. Paste INSIDE the Detail1_Format event.	Copy Code
   Dim f As MyFuncs = New MyFuncs() Me.TextBox1.Text = f.ShowMyString

   Or

   VB.NET script. Paste INSIDE the Detail1_Format event.	Copy Code
   Dim f As MyFuncs = New MyFuncs() CType(rpt.Sections("Detail1").Controls("TextBox1"), TextBox).Text = f.ShowMyString

   To create a class inside the script in C#

   C# script. Paste INSIDE the detail_Format event.	Copy Code
   MyFuncs f = new MyFuncs(); this.textBox1.Text = f.ShowMyString();

   Or

   C# script. Paste INSIDE the detail_Format event.	Copy Code
   MyFuncs f = new MyFuncs(); ((TextBox)rpt.Sections["detail"].Controls["textBox1"]).Text = f.ShowMyString();