How to Vary the width of Interactive Report Column in Oracle Apex 5

Question

I have one simple Interactive report build in Apex 5.0. Its just simple plain statement pulling the data from table.

I need to adjust the size of each column in the so that data properly appears in the report.

Right now what is happening is that i have column called customer which contains customer name. Now name is 30 to 40 characters long and in the report it is getting broken down in two lines.

I tried using the following but there is no effect of this. Could you please help me to fix this. I have 30 columns in the report.

#apexir_NAME{width: 200px;}

Answer 1

You should try this using Column Formatting and set HTML Expression value like this

<div style="display:block; width:200px">#COLUMN_NAME_OF_REPORT#</div>

Answer 2

To change interactive column width:

1. Add static id to interactive report eg. myReport
2. Add static id for column in report eg. myColumn1
3. Add to inline css of page below code:

myReport td[headers=myColumn1]{ width:100px; }

Note: before myReport td put #

Answer 3

Use min-width instead. You could use either of the following:

#apexir_NAME {min-width:200px;}

or

th#NAME {min-width:200px;}

To set all of them at once, you could try something like this:

table.apexir_WORKSHEET_DATA th {min-width:200px;}