SSRS Extract substring from string before the second string

sql-server reporting-services ssrs-2008-r2
a415 picture a415 · Dec 1, 2016 · Viewed 20.9k times · Source

I have a field which is like the following 4444-4444-TestingItem1. Is it possible for me to extract the field up until 4444-4444. if so how would I do this? What function would I use within SSRS. Please note It could be any number of characters before the first dash and before the second dash.

How can this be achieved within SSRS?

Answer

alejandro zuleta picture alejandro zuleta · Dec 1, 2016

In SSRS you can use LEFT and InStrRev functions:

=LEFT(Fields!YourField.Value,InStrRev(Fields!YourField.Value,"-")-1)

Let me know if this helps.

Related questions

How to sum SSRS Matrix Columns on Row Group

I have a report that displays the total hours a person worked for each project they are assigned to, aggregated on month. I would like to sum the total hours for each person, for each month, in SSRS 2008 R2. So, …

Read More
What are the rules for using "Internal" parameters in SSRS

There is an option to create "Internal" parameters in SSRS: In what context are they used? What are the general rules for using internal parameters?

Read More
Sub report could not be shown. Sub report works separately - Not with Main Report

I've one main report with 5 sub reports. Sub report contains more than 10 parameters. (With 10 Multi valued parameters - So I've used Join method to pass value from Main report to Sub Report) I've also tested Sub report separately and it …

Read More