question

srihari237-6810 avatar image
0 Votes"
srihari237-6810 asked Joyzhao-MSFT commented

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

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
@IanRoof-3090

sql-server-reporting-services
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

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.



0 Votes 0 ·

Still not clear how/on which condition you want to split.

0 Votes 0 ·
Show more comments

1 Answer

Joyzhao-MSFT avatar image
1 Vote"
Joyzhao-MSFT answered Joyzhao-MSFT commented

Hi @srihari237-6810 ,
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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Joyzhao-MSFT

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

Thanks & regards,
srihari

0 Votes 0 ·

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

0 Votes 0 ·