I created an APEX 4.0.0.11.23 page with an interactive report. Several columns are character strings with embedded spaces. At first, when the columns displayed they were wrapped around to as many lines as there were spaces. so I formatted it with this HTML header style:
$('td[headers="ADDRESS"]').attr("style","white-space:nowrap");
This corrected the problem but then the user requested two breaks on Column_A and Column_B. This threw the formatting off so I corrected it with this HTML header style:
$('td[headers="ADDRESS BREAK_COLUMN_A_COLUMN_B_2"]').attr("style","white-space:nowrap");
Now the lines wrap for some but not for all rows and there does not seem to be any pattern. So for instance the address for one particular row will look display in the desired format as:
530 EAST 144TH STREET
And another almost identical row will display as:
525 EAST 143RD
STREET
I thought there may be binary data in the column so I embedded the following code in the main SELECT query that drives the page”
Regexp_Replace(ADDRESS, '[^[:print:]]')
This did not help. How do I implement HTML header styles for interactive reports with multiple control breaks so that the address is formatted properly for every line? Is there a related report or page attribute that needs to be set?
BTW, the way I discovered the HTML header style for interactive reports with multiple control breaks by following this link which was provided in a related thread:
9210685
Edited by: Comet on Sep 27, 2012 11:00 AM
Edited by: Comet on Sep 27, 2012 2:32 PM
Edited by: Comet on Sep 27, 2012 2:33 PM
Edited by: Comet on Sep 27, 2012 2:34 PM
Edited by: Comet on Sep 27, 2012 2:35 PM
Edited by: Comet on Sep 27, 2012 2:36 PM