cancel
Showing results for 
Search instead for 
Did you mean: 

Inserting carriage returns into formula field plus database output

Former Member
0 Kudos

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?

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

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

Former Member
0 Kudos

That worked.  Thank you very much!

Answers (0)