Customer = 123456: CustomerABC
=Mid(Fields!Customer.Value, InStr(Fields!Customer.Value, ":") + 1)
Result: CustomerABC
=Mid(Fields!Customer.Value, 1, InStr(Fields!Customer.Value, ":") - 1)
Result = 123456
MID\INSTR FUNCTION IN SSRS
Customer = 123456: CustomerABC =Mid(Fields!Customer.Value, InStr(Fields!Customer.Value, ":") + 1) Result: CustomerABC =Mid(Fields!Customer.Value, 1, InStr(Fields!Customer.Value, ":") - 1) Result = 123456
3 Comments
RAM
6/9/2011 06:54:48 am
Really helped me. Thank you.
Reply
Sri
30/7/2013 09:56:01 pm
Thank you. This solved my problem. Saved my time.
Reply
Rohit
28/4/2017 04:58:15 am
fantastic dost, really helped me.
Reply
Your comment will be posted after it is approved.
Leave a Reply. |
Welcome!Welcome to our edition of eblog! This section will help you find various post and articles that can help you in some of your IT work especially implementing MS BI Solutions. We hope you find this section useful. If you will need further information, please send us your questions and inquiries by going to the "Contact Us" section. Enjoy reading. [Jhon S] Categories
All
|