I have a modified check format where I modified the Stub/Stub/Check to make it Check/Stub/Stub for a client that had a ton of checks left over from Quickbooks. In that particular format, the field that lists the words (One Hundred Dollars and 00/100) is driven by a Calculated Field called Calc Field 1. I just used what was there already didn't change it.
Client tells me that the words are getting cut off at the end for a check for over 240k or so. (Two Hundred Forty Three Thousand Four Hundred........) you can see, it gets long.
Initial reaction is that the field is not wide enough to handle it so I went in and expanded the field a little more. This did not work.
Next Reaction is to look at the calculated field and it was one of those FUNCTION SCRIPT with rw_SplitWordAmount function. I noticed there was a 75 in the parameters, then counded the characters, and it was right about there, so I changed that to 120 thinking it would increase it. I tested it and It looked like it worked to me, but now the client says it is still cutting off the last character.
I went into my test company and pulled up that check format and looked and apparently there were 3 fields that make this up, stacked on top of one another. Calc String 1, Calc String 2, Calc String 3. I had just removed # 2 and #3 because I just didn't know what they were for and they cluttered up my report. Now I am thinking they are the overflow ones, but still, that would look terrible to have the words printed below the other words when there is so much room for all the words on the check.
Does anyone have any experience with this? Why does changing the 75 to 120 not work and why would microsoft make 75 the character limit when I'm sure that plenty of people are cutting checks with more than 75 characters in the words part.
Where can I find out more information about these functions in report writer?
