Carriage Return in Column Names

Euan Milne shared this question 9 months ago
Answered

Folks,


I am trying to work out how to do inset a carriage return in the columns of a report. Essentially we have the column name which is "Cost [£]", what we need to do is have the "[£] "shown under the "Cost"

Comments (5)

photo
1

Hi Euan,

Just to let you know, I don't work for Yellowfin, I work for a Yellowfin partner.

This isn't in any means an elegant solution but it gets the desired results:

/21f3f1700e9115983e692d309f9efc54

The column Display is just Total Balance [£] (No special characters).

In Report Formatting, make sure wrap text is on (You have to set Style to custom to see this option)

/3dacb363b31ed3435f7456b133cd1021

In column formatting set the column width: (You'll have to figure out the width required for your column name)

/0d60a348ff9a0479b1ff10959dd6ef67

photo
1

Thanks for the msg, I can see how that would work, but it might not be the best solution for our data (data values are longer than the column names in some case, so this could cause other issues) Still hoping that it can be done with the carriage return.

photo
1

You can pad the column name with unicode blank spaces (Alt 255 on Windows, Option spacebar on Mac) to have a column that is wider than the column name. YF strips out normal spacebar spaces but allows the unicode characters.

photo
1

You may also be able to use the unicode newline character, I can't test this, I've got a Mac & it doesn't have an input method for unicode newline. On windows there's Alt 010 or 013 (Full List: https://altcodeunicode.com/).

photo
photo
1

Hey Euan,

I hope you are well!


If you would prefer not to use custom style in the column & row heading settings - Would you possibly consider using custom CSS ?

Here is a link to our wiki where there are instructions on how to configure your CSS


And also to get a more specific example > someone in the team has already created an example of the line break for a column row (not the header) linked here - However, the general steps are the same and you should only need to highlight the intended area of restyling and select 'inspect' on the right click to find the correct class.


Let me know your thoughts on this and if you end up giving it a try :)

Best Wishes,

Lesley

photo
1

Hey Euan,

I hope you are well & having a lovely week so far!


I just wanted to check in to see if you had received the previous responses? - did they help at all?

Or if you have any further questions?


Let me know - I am happy to help :)

Best Wishes,

Lesley

photo
1

Hey Euan,

I hope you are well!


I just wanted to let you know in this ticket, too, as we have not received a response, I will be marking as closed due to inactivity - as always, if you still have further queries or require additional help to get you desired results - I am happy to help! :)


Best Wishes,

Lesley