3 Replies Latest reply: Jan 21, 2013 5:53 AM by Shoaib581 RSS

    Changing Sql Report Column width

    Shoaib581
      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
          Marko Goricki
          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
            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
              Thanks Fac586,

              It helped me :)


              Shoaib