This is a migrated thread and some comments may be shown as answers.

How to group concerning the first three letters of my nvarchar field

2 Answers 15 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Kem Arda
Top achievements
Rank 1
Kem Arda asked on 28 Jul 2009, 03:23 PM
I just wantto group my records on my telerik reporting.I wantto group records concerning the first three letters of my nvarchar field. I do the following:  

= Fields.HesapKodu Like CStr(Fields.HesapKodu, 0, 3)

When i run my project it throws exception
"An error has occured while processing Report '':
The expression contains undefined function call CStr()."

Could someone pls help me?

2 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 31 Jul 2009, 09:17 AM
Hello Kem Arda,

The built-in CStr function accepts single parameter only and you have provided 3 - this is the reason for the error. Custom implementations of this functionality can be accomplished through user functions.

All the best,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
0
Kem Arda
Top achievements
Rank 1
answered on 31 Jul 2009, 12:53 PM
Hi,

Thanks for the reply. I resolved it, using MSSQL's built in function SUBSTRING(field, 1, 3).
Tags
General Discussions
Asked by
Kem Arda
Top achievements
Rank 1
Answers by
Steve
Telerik team
Kem Arda
Top achievements
Rank 1
Share this question
or