CODEWITHSUNDEEP
reporting-servicesssrs-2008
user3290489
user3290489

Reputation:

Remove left characters SSRS report expression?

Invoice number beginning with INV, but without the INV prefix.

My task is not to show the INV prefix in my report file. The current expression in SSRS is =First(Fields!InvoiceNumber.Value, "InvoiceDataSet").

I was wondering if there is a condition I could add in SSRS or change the expression to hide or not show the INV, however show the rest of the number i.e. to remove strings?

Trying to do something like =Left(Fields!InvoiceNumber.Value, len(Fields!InvoiceNumber.Value)-3) "InvoiceDataSet")

enter image description here

Upvotes: 4

Views: 7949

Answers (1)

Chris Albert
Chris Albert

Reputation: 2507

Your almost there. Change LEFT to RIGHT.

=Right(First(Fields!InvoiceNumber.Value, "InvoiceDataSet"), Len(First(Fields!InvoiceNumber.Value, "InvoiceDataSet"))-3)

Upvotes: 4

Related Questions