7 Replies Latest reply: Apr 16, 2014 1:43 PM by Doolius RSS

    Interactive report column width

    Doolius

      APEX: 4.0.2

      THEME: SAND

      SERVER: Oracle-Application-Server-10g/10.1.3.1.0 Oracle-HTTP-Server

       

      I'm wondering if there is:

      1. A different way to adjust a column's width other than using

      <span style="display:block; width:250px">Description</span>
      

      or

      2. A way to change the display name in the "filter" option.

       

      The problem I'm having is when I use the above style to adjust the column width, in the filter/serch drop down it shows up as

      <span style="display:block; width:250px">Description</span>
      

        and the users don't like that.

       

      I found the below javascript but haven't tried it yet. I would rather not have to do it this way because there are about 60 columns in my report.

       

      <script type="text/JavaScript">
      $x('apexir_S_SET_UNTS').style.width = "65px";
      $x('apexir_A_SET_UNTS').style.width = "65px";
      $x('apexir_B_SET_UNTS').style.width = "65px";
      $x('apexir_C_SET_UNTS').style.width = "65px";
      $x('apexir_D_SET_UNTS').style.width = "65px";
      $x('apexir_E_SET_UNTS').style.width = "65px";
      $x('apexir_F_SET_UNTS').style.width = "65px";
      $x('apexir_TTL SET UNTS').style.width = "80px";
      < /script>
      

       

      Thanks

      Steven

        • 1. Re: Interactive report column width
          fac586

          StevenD609 wrote:

           

          APEX: 4.0.2

          THEME: SAND

          SERVER: Oracle-Application-Server-10g/10.1.3.1.0 Oracle-HTTP-Server

          Browser/version?

           

          Unless by some mischance you're still supporting IE6, you are strongly recommended to switch to a modern, standards-based theme instead of the legacy quirks mode monstrosity that is Sand...

          I'm wondering if there is:

          1. A different way to adjust a column's width other than using

           

           

          1. <span style="display:block; width:250px">Description</span> 

          or

          2. A way to change the display name in the "filter" option. The problem I'm having is when I use the above style to adjust the column width, in the filter/serch drop down it shows up as

          1. <span style="display:block; width:250px">Description</span> 

            and the users don't like that. I found the below javascript but haven't tried it yet. I would rather not have to do it this way because there are about 60 columns in my report.

          1. <script type="text/JavaScript"
          2. $x('apexir_S_SET_UNTS').style.width = "65px"
          3. $x('apexir_A_SET_UNTS').style.width = "65px"
          4. $x('apexir_B_SET_UNTS').style.width = "65px"
          5. $x('apexir_C_SET_UNTS').style.width = "65px"
          6. $x('apexir_D_SET_UNTS').style.width = "65px"
          7. $x('apexir_E_SET_UNTS').style.width = "65px"
          8. $x('apexir_F_SET_UNTS').style.width = "65px"
          9. $x('apexir_TTL SET UNTS').style.width = "80px"
          10. < /script> 

          Use the following style sheet in the page HTML Header property:

           

          <style>
          /* Set the default width for all columns */
          .apexir_WORKSHEET_DATA th,
          .apexir_WORKSHEET_DATA td {
            width: 65px;
          }
          /* Override default for columns with different widths */
          .apexir_WORKSHEET_DATA th#apexid_TTL_SET_UNTS {
            width: 80px;
          }
          </style>
          
          
          • 2. Re: Interactive report column width
            Doolius

            I, and most of the users, are using IE9.

             

            The only problem with

            
            <style>
            /* Set the default width for all columns */  
            .apexir_WORKSHEET_DATA th,
            .apexir_WORKSHEET_DATA td {
            width: 65px;  
            }
            /* Override default for columns with different widths */  
            .apexir_WORKSHEET_DATA th#apexid_TTL_SET_UNTS {  
            width: 80px;  
            }
            </style>
            
            
            

            is that not all my columns need to be the same length. Only 2 of the 60 columns need to be widened, and they both need to be widened to about 250px.

             

            EDIT:

            Sorry, read the comments in green, but what they said didn't kick in until now. I'll try that!

             

            Message was edited by: StevenD609

            • 3. Re: Interactive report column width
              fac586

              StevenD609 wrote:

               

              I, and most of the users, are using IE9.

               

              The only problem with

              1. <style>  
              2. /* Set the default width for all columns */   
              3. .apexir_WORKSHEET_DATA th,  
              4. .apexir_WORKSHEET_DATA td {  
              5. width: 65px;   
              6. }  
              7. /* Override default for columns with different widths */   
              8. .apexir_WORKSHEET_DATA th#apexid_TTL_SET_UNTS {   
              9. width: 80px;   
              10. }  
              11. </style>  

              is that not all my columns need to be the same length. Only 2 of the 60 columns need to be widened, and they both need to be widened to about 250px.

              That's not the impression given by the code and comments in the original post, which appears to indicate that the same width is to be applied to most of the columns. If only two column widths need to be specified, use:

               

              <style>
              .apexir_WORKSHEET_DATA th#COLUMN_1,
              .apexir_WORKSHEET_DATA th#COLUMN_2 {
                width: 250px;
              }   
              </style>  
              

               

              • 4. Re: Interactive report column width
                Doolius

                That would work, but I would end up having to put in an individual width for every column to make it look correct.

                • 5. Re: Interactive report column width
                  Doolius

                  Ok to clarify, what I am wanting to do is find a different way to adjust 2 columns.

                  The current way of using <span> works, but in the filter/search drop down it has the lable as <span>......</span> and I don't like that

                   

                  Every other column needs to stay with the default width that it is now.

                  I put:

                  <style> 
                  .apexir_WORKSHEET_DATA th#CONTENT_DESC,
                  .apexir_WORKSHEET_DATA th#REMARKS
                  { 
                    width: 250px; 
                  }    
                  </style> 
                  

                   

                  (with CONTENT_DESC and REMARKS being the column names)

                  in the HTML Header of the page but nothing changed.

                   

                  Should I have put it somewhere else?

                  • 6. Re: Interactive report column width
                    fac586

                    StevenD609 wrote:

                     

                    Ok to clarify, what I am wanting to do is find a different way to adjust 2 columns.

                    The current way of using <span> works, but in the filter/search drop down it has the lable as <span>......</span> and I don't like that

                     

                    Every other column needs to stay with the default width that it is now.

                    I put:

                    1. <style>  
                    2. .apexir_WORKSHEET_DATA th#CONTENT_DESC, 
                    3. .apexir_WORKSHEET_DATA th#REMARK
                    4. {  
                    5.   width: 250px;  
                    6. }     
                    7. </style>  

                     

                    (with CONTENT_DESC and REMARKS being the column names)

                    in the HTML Header of the page but nothing changed.

                     

                    Should I have put it somewhere else?

                    No.

                     

                    I can't test anything with that combination at present. Later tonight I will have access to VMs running those versions where I can replicate this.

                    • 7. Re: Interactive report column width
                      Doolius

                      Any luck by chance with this yesterday?

                       

                      Steven