In Reporting Services you will often need to manipulate or dynamically format the report data . The built in expressions can do a lot of these, but most often you might want to format data or calculate values for which there are no expression readily available. This is where the built in custom code comes.
In one of my reports I had to calculate the Next month, having the current month and year as my input parameters.
You write your custom code in the report properties code window. Go to the report layout Select Report -> Report Properties -> Code
Public Function getNextDate(ByVal month As String, ByVal year As String) As String
Try
Dim dateNow As DateTime
dateNow =month+ "-01-" + year
Dim nextMonth As DateTime
nextMonth =
dateNow .AddMonths(1)
Return nextMonth
Catch ex As exception
Return ex.message
End Try
End Function
Now in the textbox where you want the next month displayed call the custom code
="Next Month is "+ code.
getNextDate (Parameters!Month.Value,Parameters!Year.Value)
