This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Apr 16, 2013 4:48 AM by Howard (... in Training) RSS

Reducing "between column" space in a Classic Report

Howard (... in Training) Pro
Currently Being Moderated
In order to cram more on a screen, I'd like to reduce by about half the spacing between columns in a Classic Report. Is that possible with these default settings? (I know, these probably can't go negative.)
<tr><td><table cellpadding="0" border="0" cellspacing="0" ... 
Are these even controlling the inter-column spacing? Can the space be reduced? What's required?

Howard
  • 1. Re: Reducing "between column" space in a Classic Report
    Joe Upshaw Journeyer
    Currently Being Moderated
    Howard, here is an example of some in-line css that I use to "Cram" more into a smaller space. JUst edit for your own purposes. Unfortunately, this is for an Interactive Report. However, you could just look at the dom to get the Classic css paths. (I just put this in the Region Header)
    <style type="text/css">
    #apexir_DATA_PANEL > table .apexir_WORKSHEET_DATA th {padding:0px 1px 0px 1px; margin:0px; font-size:12px; font-weight:bold; vertical-align: bottom;}
    #apexir_DATA_PANEL > table .apexir_WORKSHEET_DATA th div {padding:0px 1px 0px 1px; margin:0px; font-size:12px; font-weight:bold;}
    #apexir_DATA_PANEL > table .apexir_WORKSHEET_DATA td { padding:0px 1px 0px 1px; BORDER-LEFT: #ddd 1px solid; white-space: nowrap;  font-size:10px; }
    #apexir_DATA_PANEL > table .apexir_WORKSHEET_DATA a { text-decoration: none !important; display: block; margin: 0; }
    #apexir_DATA_PANEL > table .apexir_WORKSHEET_DATA a:hover {background-color:LightSteelBlue;}
    .look1 {padding:0px 1px 0px 1px;}
    .look2 {padding:0px 1px 0px 1px;}
    </style>
    -Joe
  • 2. Re: Reducing "between column" space in a Classic Report
    Howard (... in Training) Pro
    Currently Being Moderated
    Thanks Joe,

    Much of yesterday, I looked at your earlier thread with this code (above)-- and many other threads. I'm trying to do pattern matching but I don't see corresponding "thingies" for "#apexir_DATA_PANEL" nor "table .apexir_WORKSHEET_DATA" in a classic report. In that section of the classic report, I have
    <div id="report_316780456529052598_catch">
    <table cellpadding="0" border="0" cellspacing="0" summary=""  
    id="report_R316780456529052598"><tr><td></td></tr>
    <tr>
    <td><table cellpadding="0" border="0" cellspacing="0" summary="" class="report-standard">
    <tr ><th id="PROC_CYC_TX" class="header">Proc Cyc Tx</th><th id="PROC_NM" class="header">Proc Nm</th
    Where PROC_CYC_TX is the first displayed column.

    Is there something that corresponds to these? Is there a way to make something that will correspond?

    I suppose I'd go thru the agony of doing this for each of 18 columns if I just understood how to do one.

    ???
    Howard
  • 3. Re: Reducing "between column" space in a Classic Report
    Joe Upshaw Journeyer
    Currently Being Moderated
    No, Howard, no need to go through each column. Agreed that that would really suck.

    On the Region Defintion tab, just give the report a static ID, e.g. RR_COLLATERAL_SUMMARY
    <style type="text/css">
    #RR_COLLATERAL_SUMMARY tbody.uReportBody table.uReportStandard thead th {padding:0px 1px 0px 1px; margin:0px; font-size:12px; font-weight:bold; vertical-align: bottom;}
    #RR_COLLATERAL_SUMMARY tbody.uReportBody table.uReportStandard thead th div {padding:0px 1px 0px 1px; margin:0px; font-size:12px; font-weight:bold;}
    #RR_COLLATERAL_SUMMARY tbody.uReportBody table.uReportStandard tbody td { padding:0px 1px 0px 1px; BORDER-LEFT: #ddd 1px solid; white-space: nowrap;  font-size:10px; }
    </style>
    -Joe

    Edited by: Joe Upshaw on Apr 12, 2013 9:41 AM
  • 4. Re: Reducing "between column" space in a Classic Report
    Howard (... in Training) Pro
    Currently Being Moderated
    No joy.

    In the Reports Region, I set static ID to RR_COLLATERAL_SUMMARY. I pasted the style in the Reports Header.

    These are the changes.
    1. The right side of the report is cut off about 1/8th inch. It's actually truncated as the very narrow border no longer displays.
    2. Pagination at the very right below the last report line is no longer seen.
    3. Development GUI line at the bottom (Home, Application ..., Edit Page 1, ...) is 1/8th inch lower.

    Any idea what I missed?

    Howard
  • 5. Re: Reducing "between column" space in a Classic Report
    Joe Upshaw Journeyer
    Currently Being Moderated
    This should give you joy, Howard. Lots of it...

    The hard part was figuring out how to affect the elements that you wanted to affect. Now, we've obviously done that. So. it is simply a matter of experimenting with different CSS settings until it looks like you want it to. Try increasing the various padding settings, font size etc. until you get it looking like you want. I don't have any way of knowing that. :-(

    -Joe
  • 6. Re: Reducing "between column" space in a Classic Report
    Howard (... in Training) Pro
    Currently Being Moderated
    Thanks Joe.
    The hard part was figuring out how to affect the elements that you wanted to affect.
    Now, we've obviously done that.
    Hmm. Not so much.
    So. it is simply a matter of experimenting with different CSS settings until it looks like you want it to.
    Oh, I am.
    Try increasing the various padding settings, font size etc. until you get it looking like you want.
    <b> increasing! </b> - I'd be here forever! I want to decrease spacing.

    But seriously, I changed all 1px to 0px and reduced all fontsize by 1 and it made ABSOLUTELY no difference in 99% of the report. So this ISN'T affecting the elements as far as I can see.

    Okay. I will try to put an example on apex.oracle.com.

    Again thanks,
    Howard
    On a different note, I did have a breakthrough today when I realized the significance of a "hidden" being a item type rather than an (orthogonal) attribute/property like size, weight and width.
  • 7. Re: Reducing "between column" space in a Classic Report
    Joe Upshaw Journeyer
    Currently Being Moderated
    Yes, please do that. I tried it myself before posting and it did work for me.

    -Joe
  • 8. Re: Reducing "between column" space in a Classic Report
    flavioc Pro
    Currently Being Moderated
    Hi,
    when dealing with spacing between cells in any direction you should consider the CSS property "border-spacing" (you can get rid of cellspacing and cellpadding in the table when you master this property).
    This is a property at the TABLE level, not the TD level.

    Also, I strongly recommend that you experiment with these properties in Firefox with Firebug plugin installed or Chrome/Safari (inspect element contextual menu entry), where you can add/delete/modify on-the-fly any CSS rules until you get what you want.

    Last but not least, use a known DOCTYPE, otherwise you will get unstable results that vary greatly with the browser.
    I am using
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
           "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    and I am getting pretty equivalent results on FF/Chrome/Safari.

    Flavio

    ----
    http://www.yocoya.com
    http://oraclequirks.blogspot.com
  • 9. Re: Reducing "between column" space in a Classic Report
    Howard (... in Training) Pro
    Currently Being Moderated
    Flavio,

    Thank you. I am pretty much restricted. No browsers but IE8. No command prompt. No software installs. No admin rights to the PC. No access to anything that suggests b_l_o_g or w_o_r_d_p_r_e_s_s.

    But I'm not complaining. I can still use the monitor, keyboard and mouse. Though they have threated to take the Start Button away. (And this is 100% truthful not a parody.)

    Howard
  • 10. Re: Reducing "between column" space in a Classic Report
    flavioc Pro
    Currently Being Moderated
    have a look at this:

    http://www.w3schools.com/cssref/pr_tab_border-spacing.asp

    as I said, the border-spacing property is supported on IE8 provided a DOCTYPE is specified.

    Also border-collapse may be of some interest to you.

    Flavio

    ----
    http://www.yocoya.com
    http://oraclequirks.blogspot.com
  • 11. Re: Reducing "between column" space in a Classic Report
    Howard (... in Training) Pro
    Currently Being Moderated
    Flavio,

    I tried border-collapse a couple different times/ways yesterday. I didn't know where to make the change so random poking of code here and there produced nothing.

    This is what I'm seeing on apex.oracle.com.
    <!DOCTYPE html>
    <html lang="en" xmlns="http://www.w3.org/1999/xhtml" xmlns:htmldb="http://htmldb.oracle.com" xmlns:apex="http://apex.oracle.com">
    If I want to change it to
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
           "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    where do I make that change?

    Thanks,
    Howard
  • 12. Re: Reducing "between column" space in a Classic Report
    flavioc Pro
    Currently Being Moderated
    Howard,
    Doctype must be changed in the page template.

    Another tip that may come in handy is the #COLUMN_WIDTH#.

    See http://oraclequirks.blogspot.it/2012/12/columnwidth-in-apex-report-templates.html

    Flavio

    ----
    http://www.yocoya.com
    http://oraclequirks.blogspot.com
  • 13. Re: Reducing "between column" space in a Classic Report
    fac586 Guru
    Currently Being Moderated
    Howard (... in Training) wrote:

    Okay. I will try to put an example on apex.oracle.com.
    If you'd done that this would have been resolved hours ago...
  • 14. Re: Reducing "between column" space in a Classic Report
    Howard (... in Training) Pro
    Currently Being Moderated
    @joe,

    If you logon here
    http://apex.oracle.com/pls/apex/f?p=4550:1:2807482452656:::::

    WS: APEX_EXAMPLES_01
    USER: demo
    PW: demo

    Application BPS_f991202 page 1 shows where I am trying to reduce the spacing between columns.

    For the Report Region, I gave it a static ID and I placed the style in the Region Header as suggested. I reduce all the "1px" to "0px". I even reduce the font but it seems to have no effect. Please note that the Page Template is Application Level Default.

    If I must, I'll resort to Flavio suggestions next.

    Thanks,
    Howard

    Edited by: Howard (... in Training) on Apr 15, 2013 9:39 AM
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points