Report Attributes>Column Attributes>Column Formatting>CSS Style and add for example: width:100px"
Like the help says:
"Use this attribute to apply a style to a column value. For example, setting this attribute to 'color:#FF0000;' will result in the following html being generated:
<span style="color:#FF0000">Sample Data</span>
This will change the text color of the column to red."
You all are right but there is a problem with Firefox which is ignoring this setting.
Why? Take a look here:
http://www.velocityreviews.com/forums/t163666-firefox-ignores-the-style-width-attribute-in-the-span-tag.html
How to fix that now? I use the div tag in my sql statement for the report:
- SELECT '<b><div style="width: 150px; text-align: left">Employee no.: ' || "EMP"."EMPNO" ||
- '</div></b>' as "EMPNO",
- '<div style="border: 1px solid rgb(204, 204, 204); padding: 2px; width: 150px; background-color: rgb(225, 225, 225); text-align: center">' ||
- "EMP"."ENAME" || '</div>' as "ENAME",
- '<div style="border: 1px solid rgb(204, 204, 204); padding: 2px; width: 100px; background-color: rgb(225, 225, 225); text-align: center">' ||
- "EMP"."HIREDATE" || '</div>' as "HIREDATE",
- '<div style="border: 1px solid rgb(204, 204, 204); padding: 2px; width: 100px; background-color: rgb(225, 225, 225); text-align: center">' ||
- "EMP"."SAL" || '</div>' as "SAL",
- '<div style="border: 1px solid rgb(204, 204, 204); padding: 2px; width: 100px; background-color: rgb(225, 225, 225); text-align: center">' ||
- "EMP"."COMM" || '</div>' as "COMM"
- FROM "EMP"
- -- </div> - div tag is needed to create the css style attributes
- -- "width: 150px;" - for column width
- -- "text-align: left" - for text alignment
- -- "background-color: rgb(225, 225, 225)" - for column background color
- -- "border: 1px solid rgb(204, 204, 204)" - for border color
- -- "padding: 2px" - for empty place between text and border
Example application in action: http://apex.oracle.com/pls/otn/f?p=25472:30
Forum entry to it: http://forums.oracle.com/forums/thread.jspa?forumID=137&threadID=854151
Honestly I think there is another way to fix this issue which I don't know yet but I would really appreciate to get to know about it. :D
To all: Enjoy the weekend, have fun and DON'T think about the world economic crisis. :)
No comments:
Post a Comment