Set Cross-Tabl row cell margins

Set only row cell margins

Is there a way to control the row margin without having to set Show cell margins which affect all of the cells in the cross-tab.  I do not want the text so close to the cellborder (see the attachment).
setcellmargin.jpg
cookiejarAsked:
Who is Participating?
 
bischofb_CRNETCommented:
You can't do it, but I trick I use is to create a formula which adds a space to the front of the cell and then base the crosstab on that formula. For example, if the field was {customer.name} then I would create this formula:

" " + {customer.name};

And base the crosstab on it. Of couse, you can add as many spaces as you like to change the indentation.
0
 
cookiejarAuthor Commented:
I tried that but it appears in the cell as:
   ASM V3 MCE TESTING
ADMINISTRATION

when I would like it to look like
    ASM V3 MCE TESTING
    ADMINISTRATION
0
 
bischofb_CRNETCommented:
Yes, the fields that are longer than one line will wrap. I don't know if there is a way to do what you want then. The only option would be to truncate the line at a certain number of characters. But this would be unacceptable if the report requires the full text field.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.