how to display the exact value of a field from db to crystal report

Question

1.00/5 (1 vote)

See more:

VS2010

Hi
I have a field name serial number whose datatype is nvarchar(25).
As i am entering data from front end as 0001 as serial number.

data is getting saved in database as 0001 but when i am trying to print it in crystal report from database. its coming as 1.

How do i make the change? As i want it to be printed the same way as it is there in db as 0001

can anyone please help me.

I have seen many posts in google. All are suggesting to make '000' as string and totext function to use.

I dont want to make the ultimate result as a string.

As it might happen that i might enter some serial numbers as 001 or 0001-2 or OOO24-2
like this.

Thanks
Sudeshna

Posted 11-Feb-15 17:14pm

sudeshna from bangkok

Add a Solution

2 solutions

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)

Sinisa Hajnal · Answer 1 · 2015-02-11T23:03:00

Solution 1

Go to the element, right click, select Formatting and change autoformat to text. I don't have CR in front of me so I cannot give exact step by step, but it shouldn't be hard to find based on this.

If this helps please take time to accept the solution. Thank you.

Posted 11-Feb-15 23:03pm

Sinisa Hajnal

nirav raval · Answer 2 · 2015-02-11T23:21:00

Solution 2

Right("0000"&{table.field}),5)

Padding a fixed number with leading zeros up to a fixed length

Posted 11-Feb-15 23:21pm

nirav raval

Comments

sudeshna from bangkok 12-Feb-15 5:23am

I solved it myself. i just refreshed my data source. Thanks