Showing posts with label Report Expression. Show all posts
Showing posts with label Report Expression. Show all posts

Camel case on SSRS Report Expression, D365FO




Camel case on SSRS Report Expression



Today I found a very good function in SSRS reporting services, which  Converts the first letter of every word in string to uppercase.



=StrConv(Fields!Name.Value,3)



But using “strConv” function we can simply achieve.

Here is the syntax:

=StrConv(Fields!Name.Value, vbProperCase)   
or

=StrConv(Fields!Name.Value,3)

Virtual Fields Vs Computed Fields

  Virtual Field: A virtual field in D365FO is a field that doesn't have a direct representation in the database. It's a field that y...