News and Announcements icon

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 Community member

6

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

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

gdrenteria 12,338 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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans