Conclusion, reporting Services is a platform to create, manage, and deliver reports. Having the ability to embed custom code inside of these reports allows flexibility in what you can achieve. Hopefully, future versions will allow access to more of the internal events and objects of the engine. Visual Basic functions such as InStr and DateAdd are present, as are Iif and Switch. However, the product designers could not predict your every need, and embedded code allows you to implement functions with custom code.
W can enter the following expression, which assumes we have a query returning a Quantity column: tColor(Fields! Lue one of the nice features of Reporting Services is the ability to use an expression instead of a hard value on any property. When So where does the code live? Inside the RDL file. Right click the RDL file in Solution Explorer and take a look at the XML markup. Inside you'll see: Report. Code Public Shared Function SetColor(ByVal Value As Integer) As String, setColor "Red". Why Embed Code? Reporting Services gives you a number of functions to use in a report. For instance, there are functions to sum and average numbers, and functions to count values.