Add a report column with data derived from a method or DLL call

See more:

C#

VB

dataset

reporting

, +

I have created a report in VS 2013 that gets user data from a table in sql using c#. I have connected to sql and have a dataset for the table.

I quickly created it by saying I wanted a report based upon a sql table.

I have a report that displays the data, however now I want to add the user name. The user name is not stored on the table but can be derived from a dll call or from the following VB code...

Public Function getname(lanid As String) As String
    Dim app As Microsoft.Office.Interop.Outlook.Application
    Dim appNameSpace As Microsoft.Office.Interop.Outlook._NameSpace

    Dim recip As Microsoft.Office.Interop.Outlook.Recipient
    Dim ae As Microsoft.Office.Interop.Outlook.AddressEntry

    app = New Microsoft.Office.Interop.Outlook.Application
    appNameSpace = app.GetNamespace("MAPI")
    recip = appNameSpace.CreateRecipient(lanid)
    recip.Resolve()
    Try
        ae = recip.AddressEntry
    Catch ex As Exception
        getname = "Not found"
        Exit Function
    End Try

    Dim name As String
    name = ae.Name
    getname = name
End Function

I have tried the following but I just get an #error in the column...

1, Added references to the MS DLLs required for above
2, Added this code to custom code section
3, Added a column and set the expression to
=Code.getname("F468s8")

What is wrong? What is the correct way to derive data from a method call or is this too complicated for a report?

It looks like the dataset is based off the table so I cannot add a column to that with a view to filling in the data before I display the report?

I guess the overall question for you report experts is, how would you code this. All I need is a simple example of how to call an inline method/dll OR do I need to create a new dataset and manually populate that first?

I am new to reporting (in case you had not realized)!!!

Thanks in advance
John