Solved

How to trim value in ssrs report

Posted on 2011-02-22
2
2,174 Views
Last Modified: 2012-05-11
In the result , i have  the data as follows,

:ddf :rrrrr:dfdf

I have to remove the first character ":" only from the data

the result should be as follows,
 ddf :rrrrr:dfdf


How should do it?!
For ex  LTrim(!Fields.sss.Value),":"
0
Comment
Question by:Manikannan
  • 2
2 Comments
 

Accepted Solution

by:
Manikannan earned 0 total points
ID: 34959390

I have used the following and got the result.

=Mid(First(Fields!C_ADDRESS_INFO.Value),2,250)
0
 

Author Closing Comment

by:Manikannan
ID: 34959393
I got the result by using this query
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Best 3rd party SQL Dashboard Reporting Tool? 4 53
Cant preview report change unless report is save first 5 30
SSRS 2016 KPI 2 17
Find control on SSRS report 1 4
Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question