Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Don't dismiss a good idea just because you don't like the source
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!


What's this GetChar Function in SQL Server Reporting Services?

I have been creating reports, and training clients to write their own reports using SQL Server Reporting Services, and until know, I have never noticed the function GetChar.

For those of you who are not aware of this function, in SSRS it is described as follows:

Returns a Char value representing the character from the specified index in the supplied string.
In lay mans terms GetChar, allows users to extract a character from a specific position in a text string.

=GETChar(Tablename!FieldName.Value, 8)

Granted I could have used the Mid() function, but this is so much cleaner

If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us


Name *

Email Address *

Comment *

To prove you are human what is:

37 + 13 =