How to Add Custom Code in SSRS Report - SQL Server Reporting Services (SSRS) Interview Questions and Answers

There could be situations where we don't have built in function/s available in SSRS. we can write our custom functions/code in SSRS Report.

Let's say if we would like to create a function that should be able to accept two string fields and return us concatenated output. For example,This function can be used to concatenate first name and last Name columns. Again this is just to provide you example, We know that concatenation can be done by using expressions.

Here are the steps to add the Custom Code in SSRS.


Step 1: 

Go to Report Tab and then go to Report Properties in SQL Server Data Tools(SSDT)

Step 2:

Write your code in Editor. You can use sample code provided.

Public Function StrConcate(byVal FirstName as string, byVal LastName as string) As string
   dim FullName as String
        FullName = FirstName+" "+LastName 
  return FullName 
End Function 

How to write Custom Code in SSRS report - SSRS Interview Questions and Answers


Step 3: Use the Function we wrote

Let's say if I have two fields called SalePersonFName and SalePersonLName and I would like to concatenate, I can use StrConcate function in expressions as shown below.

How to use Custom Code in SSRS Report - SSRS Interview Questions and Answers


7 comments:

  1. I haven’t any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us. custom writing

    ReplyDelete
  2. all expain by step by step . good report.

    ReplyDelete
  3. The buying and offering of a home can be a difficult and frustrating task. For starters reason or still another, many individuals and individuals It Sevices

    ReplyDelete
  4. We've all heard the phrase "we've more computing energy on our pc than we'd in the very first place taxi", or some plan of. Managed IT Services

    ReplyDelete
  5. Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. los angeles it support

    ReplyDelete
  6. I have recently started a blog, the info you provide on this site has helped me greatly. Thanks for all of your time & work It Support

    ReplyDelete