web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Fetch combination of 3...

Small and medium business | Business Central, N...

Suggested Answer

Fetch combination of 3 Numeric digits ending with colon in a text string in business central

(1) Share

Report

Report

Posted on by CU09081806-1

12

I have a requirement that he will add text string in Business Central field and I have to display it on SSRS report but problem is that he want to line break the text string on a condition that if a text sting contains combination of 3 numeric characters ending with colon, like : 010: , 020: , 022: etc. in any position of text string the text string breaks and continue on next line in SSRS. Is anyone have any idea about that?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Gerardo Rentería Ga... 25,078 Most Valuable Professional on at

Like (0)

Report

Fetch combination of 3 Numeric digits ending with colon in a text string in business central

Hi

You could help yourself with some chain functions from BC, here are some links to practical exercises.

Dynamics 365 Business Central: How to use String Functions in AL (StrPos, CopyStr, PadStr, StrLen, LowerCase, SelectStr…) | Dynamics 365 Lab (yzhums.com)

Dynamics 365 Business Central: How to extract characters from a string (indexing with []) | Dynamics 365 Lab (yzhums.com)
Or alternatively use transformations from the SSRS

Transform Data with Transformations - SQL Server Integration Services (SSIS) | Microsoft Learn

Best regards

Gerardo

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 3,377

#2

Jainam M. Kothari 2,696 Super User 2025 Season 2

#3

YUN ZHU 1,512 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans