Carriage Return in total field

[Former Member]

I want to put a carriage return in the total/sum field. I am doing this so the report will show the column sum and underneath it a percent. I am doing this is the format editor - Display String with this code:

ToText(ToText(currentfieldvalue) + chr(13) + totext(Int((TC123/currentfieldvalue)*100),"##") + "%")

From what I read the chr(13) should work, but it doesn't.

Any suggestions on how this can be accomplished?

[Former Member · Accepted solution]

Hi David,

I tried expanding the cell height but still it shows in the same line. I think you can try this

insert the same summary field once again in field to summarize in the cross tab and suppress this in the columns and in the total right click on the newly added field and go to Display string and write this

totext(Int((TC123/currentfieldvalue)*100),"##") + "%"

Hope this helps!

Raghavendra

[Former Member · Accepted solution]

I am not quite sure what you are saying about inserting another sum. Idealling I would like this all to be in the one total/sum row. Will you please elaborate?

Thanks

[former_member260594 · Accepted solution]

If you inserted the same summary field as the second summarized field in the crosstab and they were set to Vertical (in Customize style tab) then the first summary would show original value. You could format the second summary with the percent sign using the display string. As the second value would appear below the first this would give a simialr appearance as using the carriage return to display the second value below.

[Former Member · Accepted solution]

I see what you are saying. I think the report I am supposed to create has a lot of obstacles. I have two summarized fields and they have to be horizontal on the report. I need to show the sum of both of these fields. Then on the next line I need to show the percent difference with these two sums. The reason it has to be in the next row is because there are several columns on the report and adding a third summarized field will prevent it all from being on one page. I guess that is why I am trying to figure out some kind of work around so I can do this.

[Former Member]

When you create a field that you want multiple lines, you need to turn in on so that it can be more then one line. This is found by right-clicking on the field, selecting the common tab, and checking the "Can Grow" field.

[Former Member]

I am using a cross tab report and the can grow option is not available.