Example:
Dim table As New DataTable ‘Define a Table in Memory table.Columns.Add("FID", System.Type.GetType("System.Int64")) table.Columns.Add("NAME", System.Type.GetType("System.String")) Dim i As Integer ‘Fill the Table with Data For i = 1 To 20 Dim newRow As DataRow newRow = table.NewRow newRow.Item("FID") = i newRow.Item("NAME") = "a" & i & "bbb" table.Rows.Add(newRow) Next Report.SetDataSource("MyMemoryTest", table)
In the report definition, you then can treat this table like a database table and apply a SQL statement:
select * from MyMemoryTest where Fid={Fid} Set the SQLSource property to Memory.