Forum Discussion

RobertRR's avatar
RobertRR
Frequent Visitor
2 years ago

How to display objects in a grouping

I would like to know if there is any way to display the query values for an external data source in object format and not in plain text with the concatenated values. To do this, I need to create a gr...
Report
RobertRR's avatar
RobertRR
Frequent Visitor
2 years ago

I understand, I expected that. However, I have no idea how to do this with custom code, I searched the Microsoft documentation and didn't find anything related. I would be grateful if you could help me find a code example.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi RobertRR ,

Here is the sample:

Public Function GetUsers(ByVal param As Integer) As String
    Dim sqlCon As New System.Data.SqlClient.SqlConnection
    Dim cmd As New System.Data.SqlClient.SqlCommand
    Dim dRet As String
    Dim sCmdText As String

    sqlCon.ConnectionString = "data source=MYSERVER;initial catalog=MYDB;Integrated Security=true"

    cmd = New System.Data.SqlClient.SqlCommand
    sCmdText = "SELECT dbo.udf_MyFunction(" 
    'cmd.CommandType = CommandType.Text
    cmd.Connection = sqlCon
    cmd.CommandTimeout = 0

    sCmdText = sCmdText & param
    sCmdText = sCmdText & ")"

    cmd.CommandText = sCmdText
    If sqlCon.State <> System.Data.ConnectionState.Open Then
    sqlCon.Open()
    End If
    dRet = cmd.ExecuteScalar() & ""     
    sqlCon.Close()

    Return dRet

End Function

Below is the official link will help you:

Custom code and assembly references in expressions in a paginated report in Report Designer - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.