Splitting field value to multiple textboxes using custom code in ssrs report.

Question

Splitting field value to multiple textboxes using custom code in ssrs report.

srihari 237 1

Hi all,
I have a requirement in that we a field value(amount in words). I need to split the same field value to multiple text boxes(more than 2 text boxes).
i followed the below link, with that i can get upto two textboxes.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8c705716-1ccb-45b9-84ac-fc8c80dc02a5/text-box-sending-large-amounts-of-text-to-next-page-microsoft-please-help?forum=sqlreportingservices
I'm not familiar with the custom code this is the first time i'm using it.
Please can anyone help me.
Thanks & regards
srihari
@Ian Roof

Olaf Helper 46,461 Reputation points

2021-06-02T06:50:57.48+00:00

Please provide more information, like sample values and the expected result; what do you want to splitt by which conditions?
srihari 237 1 Reputation point

2021-06-02T07:09:27.697+00:00

There is a field called amount in word and 3 textboxes in report.
Line1 is having 3cm textbox, line2 having 5cm textbox and line3 having 5cm textbox.
In all the three lines will use the same field value(amount in words).
The text should not exceed the textbox size.

Example:
neuf cent quatre-vingt-dix-neuf

`millions neuf cent quatre-vingt-dix-neuf

mille neuf cent quatre-vingt-dix-neuf.

It will come like this and there is space between each line appx 1cm.
Olaf Helper 46,461 Reputation points

2021-06-02T11:04:10.137+00:00

Still not clear how/on which condition you want to split.
srihari 237 1 Reputation point

2021-06-02T12:44:30.97+00:00

Condition is showing the words which are fit inside line1, line2 and line3 respectively.

1 answer

Your answer

Olaf Helper 46,461 Reputation points

2021-06-02T06:50:57.48+00:00

Please provide more information, like sample values and the expected result; what do you want to splitt by which conditions?
srihari 237 1 Reputation point

2021-06-02T07:09:27.697+00:00

There is a field called amount in word and 3 textboxes in report.
Line1 is having 3cm textbox, line2 having 5cm textbox and line3 having 5cm textbox.
In all the three lines will use the same field value(amount in words).
The text should not exceed the textbox size.

Example:
neuf cent quatre-vingt-dix-neuf

`millions neuf cent quatre-vingt-dix-neuf

mille neuf cent quatre-vingt-dix-neuf.

It will come like this and there is space between each line appx 1cm.
Olaf Helper 46,461 Reputation points

2021-06-02T11:04:10.137+00:00

Still not clear how/on which condition you want to split.
srihari 237 1 Reputation point

2021-06-02T12:44:30.97+00:00

Condition is showing the words which are fit inside line1, line2 and line3 respectively.

Answer 1

Joyzhao-MSFT 15,621

Hi @srihari 237 ,
What does the field value look like?
You could check this link: Splitting a string in SSRS 2008 R2 using a custom code for three columns.
Regards,
Joy

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

srihari 237 1 Reputation point

2021-06-02T08:08:17.14+00:00

Hi @Joyzhao-MSFT

It is a string field and there is no special characters in-between to split.

Thanks & regards,
srihari
Joyzhao-MSFT 15,621 Reputation points

2021-06-04T09:56:34.857+00:00

This is out of my ability, If you urgently need to resolve the issue,I suggest you choose telephone support service (some cost is required)
https://support.microsoft.com/en-us/help/4051701/global-customer-service-phone-numbers
https://support.microsoft.com/en-us/supportforbusiness/productselection

Share via

Splitting field value to multiple textboxes using custom code in ssrs report.

1 answer

Your answer