This discussion is archived
3 Replies Latest reply: Jan 21, 2013 3:53 AM by Shoaib581 RSS

Changing Sql Report Column width

Shoaib581 Newbie
Currently Being Moderated
Hi,

I am using Apex 4.1

Can anyone tell me how we can change the width of Sql report. For IR report we can do it using the following code,

<style>
table.apexir_WORKSHEET_DATA td[headers="Col Name"] {
_width: 500px;
min-width: 400px;</style>

Please help me with Sql Report.

Thanks,
Shoaib

Edited by: Shoaib581 on Jan 21, 2013 3:05 AM
  • 1. Re: Changing Sql Report Column width
    MarkoGoricki Journeyer
    Currently Being Moderated
    Hi Shoaib581,

    Check out your report template if you have defined #COLUMN_WIDTH# in Column Heading Template field. If not, add it inside <th>. Then you can declarative set column width in report attributes (column width property).

    Br,
    Marko Goricki
    ----------------------------
    http://apexbyg.blogspot.com/
  • 2. Re: Changing Sql Report Column width
    fac586 Guru
    Currently Being Moderated
    Shoaib581 wrote:
    Hi,

    I am using Apex 4.1

    Can anyone tell me how we can change the width of Sql report. For IR report we can do it using the following code,
    Always post code using <tt>\
    ...\
    </tt> tags:
    <style>
    table.apexir_WORKSHEET_DATA td[headers="Col Name"] {
    _width: 500px;
    min-width: 400px;</style>
    Please help me with Sql Report.
    Either use the same CSS approach by adding a static region ID to the report region and adding the style sheet to the page HTML Header:
    <style>
    #static-region-id td[headers="COL_ALIAS"] {
      width: 400px;
    }
    <style>
    OR

    Use the Column Definition > Column Width column attribute to set the width in pixels (note that this value is just the number of pixels "400", no unit is specified as in CSS).

    OR

    Use the Column Formatting > CSS Class column attribute to set the width of the column contents:
    display: block; width: 400px;
  • 3. Re: Changing Sql Report Column width
    Shoaib581 Newbie
    Currently Being Moderated
    Thanks Fac586,

    It helped me :)


    Shoaib

Legend

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