on 02-05-2016 9:42 PM
I have Two fields: {SQL.NumberField} and {SQL.ActualTextField}
In my formula field {@TextField} I want to insert a number of carriage returns equal to the value of {SQL.NumberField} followed by whatever is in {SQL.ActualTextField}
Anyone have any suggestions on how they would go about doing this?
Hi Pez,
Use this code in the formula field:
ReplicateString(chr(13), {SQL.NumberField}) & {SQL.ActualTextField}
After you drag and drop this formula on the report, right-click it > Format field > Common tab > Check 'Can Grow'.
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.