how to separate Integer numbers stored in one field to several fields in report - NAV or SSRS

(0) Share

Report

Posted on by Suhail

150

Hi All,

i have Bank IBAN No. stored in one field as Integer i want to sepreate it diffrent fields in report because this report is a template and should every number display in the exact position.

please guy do anyone have idea how we can do it SSRS ?

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

In your report dataitem (C/AL), create N different strings with the part of the number you want and then dispplay these strings in your report.

To convert your number in a string, use FORMAT(YourNumber). Then split your string into N substrings with COPYSTR.

Was this reply helpful? Yes No
Suhail 150 on at

Like (0)

Report

Sorry I didn't get it

Was this reply helpful? Yes No
Suhail 150 on at

Like (0)

Report

i got it now, and its working ... Thanks Alot

Was this reply helpful? Yes No

Community site session details

how to separate Integer numbers stored in one field to several fields in report - NAV or SSRS

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Featured topics

Product updates

Community site session details

how to separate Integer numbers stored in one field to several fields in report - NAV or SSRS

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Featured topics

Product updates