Adding leading zeros to Record Number field in Crystal Reports 13

up vote
0
down vote

favorite

I'm trying to add leading zeros to 'Record Number' special field provided by Crystal Reports 13.

Eg:

Record Number 1 should be '001'

Record Number 20 should be '020'

I have noticed that there's a related post about customizing table fields by using ToText({table.field},"000"). But this approach doesn't work when I use {recordnumber} instead of {table.field}.

edited Nov 16 at 4:03

asked Nov 14 at 11:15

Praveena Goonasekera

Possible duplicate of Padding a fixed number with leading zeros up to a fixed length
– MatSnow
Nov 14 at 14:26

@MatSnow edited the main question according to my problam.
– Praveena Goonasekera
Nov 16 at 4:08

1

@PraveenaGoonasekera you are not going to use {recordnumber} just use recordnumber. { } are just for fields, see my answer. Just tested here and it's working pretty fine.
– jhenrique
Nov 16 at 6:21

add a comment |

up vote
0
down vote

favorite

I'm trying to add leading zeros to 'Record Number' special field provided by Crystal Reports 13.

Eg:

Record Number 1 should be '001'

Record Number 20 should be '020'

edited Nov 16 at 4:03

asked Nov 14 at 11:15

Praveena Goonasekera

Possible duplicate of Padding a fixed number with leading zeros up to a fixed length
– MatSnow
Nov 14 at 14:26

@MatSnow edited the main question according to my problam.
– Praveena Goonasekera
Nov 16 at 4:08

1

@PraveenaGoonasekera you are not going to use {recordnumber} just use recordnumber. { } are just for fields, see my answer. Just tested here and it's working pretty fine.
– jhenrique
Nov 16 at 6:21

add a comment |

up vote
0
down vote

favorite

I'm trying to add leading zeros to 'Record Number' special field provided by Crystal Reports 13.

Eg:

Record Number 1 should be '001'

Record Number 20 should be '020'

edited Nov 16 at 4:03

asked Nov 14 at 11:15

Praveena Goonasekera

I'm trying to add leading zeros to 'Record Number' special field provided by Crystal Reports 13.

Eg:

Record Number 1 should be '001'

Record Number 20 should be '020'

crystal-reports sap

edited Nov 16 at 4:03

asked Nov 14 at 11:15

Praveena Goonasekera

edited Nov 16 at 4:03

asked Nov 14 at 11:15

Praveena Goonasekera

edited Nov 16 at 4:03

asked Nov 14 at 11:15

Praveena Goonasekera

asked Nov 14 at 11:15

Praveena Goonasekera

asked Nov 14 at 11:15

Praveena Goonasekera

Possible duplicate of Padding a fixed number with leading zeros up to a fixed length
– MatSnow
Nov 14 at 14:26

@MatSnow edited the main question according to my problam.
– Praveena Goonasekera
Nov 16 at 4:08

1

@PraveenaGoonasekera you are not going to use {recordnumber} just use recordnumber. { } are just for fields, see my answer. Just tested here and it's working pretty fine.
– jhenrique
Nov 16 at 6:21

add a comment |

Possible duplicate of Padding a fixed number with leading zeros up to a fixed length
– MatSnow
Nov 14 at 14:26

@MatSnow edited the main question according to my problam.
– Praveena Goonasekera
Nov 16 at 4:08

1

@PraveenaGoonasekera you are not going to use {recordnumber} just use recordnumber. { } are just for fields, see my answer. Just tested here and it's working pretty fine.
– jhenrique
Nov 16 at 6:21

Possible duplicate of Padding a fixed number with leading zeros up to a fixed length
– MatSnow
Nov 14 at 14:26

@MatSnow edited the main question according to my problam.
– Praveena Goonasekera
Nov 16 at 4:08

@PraveenaGoonasekera you are not going to use {recordnumber} just use recordnumber. { } are just for fields, see my answer. Just tested here and it's working pretty fine.
– jhenrique
Nov 16 at 6:21

add a comment |

1 Answer
1

active

oldest

votes

up vote
0
down vote

Create a new formula to your desired field, then add this:

Right(("000" + ToText(({Comand.YourField}), 0, "")), 3)

That's it (note that if you need more zeros you can edit the formula. For 10 digits it will be Right(("0000000000" + ToText(({Comand.YourField}), 0, "")), 10) and so on.

As you completed your question, if you want RecordNumber use this way:

Right(("000" + ToText((RecordNumber), 0, "")), 3)

edited Nov 16 at 6:34

answered Nov 14 at 11:26

jhenrique

456312

Hi @jhenrique, '{Comand.YourField}' only gives access to fields in my data source. How to use the Special Field 'Record Number' provided by CR to be used in that instance?
– Praveena Goonasekera
Nov 16 at 4:25

You can use the RecordNumber, it's a variable just like other normal data source field. Create a new formula, but using like this: Right(("000" + ToText((RecordNumber), 0, "")), 3)
– jhenrique
Nov 16 at 6:17

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53298933%2fadding-leading-zeros-to-record-number-field-in-crystal-reports-13%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

up vote
0
down vote

Create a new formula to your desired field, then add this:

Right(("000" + ToText(({Comand.YourField}), 0, "")), 3)

That's it (note that if you need more zeros you can edit the formula. For 10 digits it will be Right(("0000000000" + ToText(({Comand.YourField}), 0, "")), 10) and so on.

As you completed your question, if you want RecordNumber use this way:

Right(("000" + ToText((RecordNumber), 0, "")), 3)

edited Nov 16 at 6:34

answered Nov 14 at 11:26

jhenrique

456312

Hi @jhenrique, '{Comand.YourField}' only gives access to fields in my data source. How to use the Special Field 'Record Number' provided by CR to be used in that instance?
– Praveena Goonasekera
Nov 16 at 4:25

You can use the RecordNumber, it's a variable just like other normal data source field. Create a new formula, but using like this: Right(("000" + ToText((RecordNumber), 0, "")), 3)
– jhenrique
Nov 16 at 6:17

add a comment |

up vote
0
down vote

Create a new formula to your desired field, then add this:

Right(("000" + ToText(({Comand.YourField}), 0, "")), 3)

That's it (note that if you need more zeros you can edit the formula. For 10 digits it will be Right(("0000000000" + ToText(({Comand.YourField}), 0, "")), 10) and so on.

As you completed your question, if you want RecordNumber use this way:

Right(("000" + ToText((RecordNumber), 0, "")), 3)

edited Nov 16 at 6:34

answered Nov 14 at 11:26

jhenrique

456312

Hi @jhenrique, '{Comand.YourField}' only gives access to fields in my data source. How to use the Special Field 'Record Number' provided by CR to be used in that instance?
– Praveena Goonasekera
Nov 16 at 4:25

You can use the RecordNumber, it's a variable just like other normal data source field. Create a new formula, but using like this: Right(("000" + ToText((RecordNumber), 0, "")), 3)
– jhenrique
Nov 16 at 6:17

add a comment |

up vote
0
down vote

Create a new formula to your desired field, then add this:

Right(("000" + ToText(({Comand.YourField}), 0, "")), 3)

That's it (note that if you need more zeros you can edit the formula. For 10 digits it will be Right(("0000000000" + ToText(({Comand.YourField}), 0, "")), 10) and so on.

As you completed your question, if you want RecordNumber use this way:

Right(("000" + ToText((RecordNumber), 0, "")), 3)

edited Nov 16 at 6:34

answered Nov 14 at 11:26

jhenrique

456312

Create a new formula to your desired field, then add this:

Right(("000" + ToText(({Comand.YourField}), 0, "")), 3)

That's it (note that if you need more zeros you can edit the formula. For 10 digits it will be Right(("0000000000" + ToText(({Comand.YourField}), 0, "")), 10) and so on.

As you completed your question, if you want RecordNumber use this way:

Right(("000" + ToText((RecordNumber), 0, "")), 3)

edited Nov 16 at 6:34

answered Nov 14 at 11:26

jhenrique

456312

edited Nov 16 at 6:34

answered Nov 14 at 11:26

jhenrique

456312

answered Nov 14 at 11:26

jhenrique

456312

answered Nov 14 at 11:26

jhenrique

456312

Hi @jhenrique, '{Comand.YourField}' only gives access to fields in my data source. How to use the Special Field 'Record Number' provided by CR to be used in that instance?
– Praveena Goonasekera
Nov 16 at 4:25

You can use the RecordNumber, it's a variable just like other normal data source field. Create a new formula, but using like this: Right(("000" + ToText((RecordNumber), 0, "")), 3)
– jhenrique
Nov 16 at 6:17

add a comment |

Hi @jhenrique, '{Comand.YourField}' only gives access to fields in my data source. How to use the Special Field 'Record Number' provided by CR to be used in that instance?
– Praveena Goonasekera
Nov 16 at 4:25

You can use the RecordNumber, it's a variable just like other normal data source field. Create a new formula, but using like this: Right(("000" + ToText((RecordNumber), 0, "")), 3)
– jhenrique
Nov 16 at 6:17

Hi @jhenrique, '{Comand.YourField}' only gives access to fields in my data source. How to use the Special Field 'Record Number' provided by CR to be used in that instance?
– Praveena Goonasekera
Nov 16 at 4:25

You can use the RecordNumber, it's a variable just like other normal data source field. Create a new formula, but using like this: Right(("000" + ToText((RecordNumber), 0, "")), 3)
– jhenrique
Nov 16 at 6:17

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Some of your past answers have not been well-received, and you're in danger of being blocked from answering.

Please pay close attention to the following guidance:

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Cfrgtkky