Announcements
Hi:
I'm modifying Report ID 10412 (Report Selection - Bank), which is the A/P check.
Below is a screenshot of the Amount in Words, and below that screenshot are the two formula expressions used for this. (My guess is that the second formula is some sort of "overflow" field.)
I need for the asterisks in the beginning to appear at the end, instead. And, the phrase "US DOLLARS" need not appear.
How do I meet these two requirements?
Thank you!
John
=Cstr(Choose(97,Split(Cstr(ReportItems!FooterInfo.Value), Chr(177))))
=Cstr(Choose(98,Split(Cstr(ReportItems!FooterInfo.Value), Chr(177))))
Try it as the Choose(98,Split(Cstr(ReportItems!FooterInfo.Value) inside the previously discussed right and len functions.
Hi Josh:
I'm afraid that I got an error, upon trying this. Below are the two "codings" that I made -- one for each field for check amount in words.
Any thoughts?
John
=right(Cstr(Choose(97,Split(Cstr(ReportItems!FooterInfo.Value), Chr(177))))).GetData(1,2),len(Cstr(Choose(97,Split(Cstr(ReportItems!FooterInfo.Value), Chr(177))))).GetData(1,2))-4)
=right(Cstr(Choose(98,Split(Cstr(ReportItems!FooterInfo.Value), Chr(177))))).GetData(1,2),len(Cstr(Choose(98,Split(Cstr(ReportItems!FooterInfo.Value), Chr(177))))).GetData(1,2))-4)
Not quite a copy/paste. Add the suggested functions to the existing content. You can copy the existing content to paste it into the suggested functions as you need the string twice. Give it a try
Thanks, Josh! Do I simply paste the code from the original posting into the text box?
And, since there are two fields for amount in words from what I see, do I paste into both text boxes?
John
At the bottom of your original post you have what looks to be content from a text box on a RDLC layout. That is where the code should go.
Also need the asterisks moved.
I'm leery about messing with currency stuff just to make a modification.
Thanks, though!
But, where do I "put that coding"? That's what I need help with. When it comes to programming BC, I don't even know where to begin.
GB version looks a bit different to yours but effectively the Right() and Len() functions will do what you need. Adapt this to fit yours: right(Code.GetData(1,2),len(Code.GetData(1,2))-4)
Gives you this type of output:
Do you have a currency code for USD setup and is the description US Dollars? What happens if you simply remove the description?
Thanks, Josh!
Do I place that code inside of a text field on the report? I'm not very swift on programming. :)
John
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156