Pages

Tuesday, September 9, 2014

Add custom code to report builder/SSRS



Sometimes ,your requirement may not be done with the default functions or custom expressions.This is when the custom code comes into picture.Following are the steps to embed the custom code in the Report builder/SSRS

1.In Design mode,right click outside the border of the report and click on Report properties
2.Click on code
3.Add the custom code to the window as shown below.
4.Click Ok.(Errors are only shown when you run the report)
5.Following is the way to call the code  in the  corresponding cell of the report.


=Code.BatchServiceStatusString(Fields!BatchServiceStatus.Value)


                The meaning of the above code snippet is for the corresponding Fields!BatchServiceStatus.Value there would be a corresponding return value based on the condition satisfied.


No comments:

Post a Comment