Adding space in a string in .rdlc report

Question

0.00/5 (No votes)

See more:

I am using .rdlc reports in VB.Net

I am getting a 7 chars varchar value from database. The characters are like "5647912". Now in the report I want to show them like this "564 7912". How do I do this??

Currently I am using "=First(Fields!CardNo.Value)" How can I achieve my desired result??

Thanks

Posted 7-Apr-11 20:20pm

umarbangash

Add a Solution

2 solutions

Solution 1

If the string contains numbers, I think the easiest way is to cast it first to for example integer (http://msdn.microsoft.com/en-us/library/ms141704.aspx[^])

And then format it using number format models http://msdn.microsoft.com/en-us/library/ms157406(v=SQL.100).aspx[^]

Posted 7-Apr-11 20:27pm

Wendelius

Comments

umarbangash 8-Apr-11 3:06am

thnx for the suggestion :-) I didnt try it though coz I think it is difficult for me to do! but thnx :-)

Wendelius 8-Apr-11 13:12pm

You're welcome

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mahendra.p25 · Accepted Answer · 2011-04-07T20:53:00

Solution 2

try this

SQL

For i As Integer = 0 To str.Length - 1
    If i = 3 Then
        str = str.Insert(i, " ")
    End If
Next

Posted 7-Apr-11 20:53pm

Mahendra.p25

Comments

umarbangash 8-Apr-11 3:05am

Thnx... U rang my bell :-)

I excluded the loop though and directly put 3 instead of i... And then I reset the datatable column value and sent it to report!

Dim Str As String = dt.Rows(0)("CardNo").ToString()
Str = Str.Insert(3, " ")
dt.Rows(0)("CardNo") = Str

Mahendra.p25 8-Apr-11 3:07am

great...