2 Replies Latest reply on Dec 5, 2012 12:04 AM by Snowman

    Named column report template with 2 rows/record displays null row at top

      I have been able to create a named column report template with 2 rows per record for a tabular form, however it appears to only hide the first row of the initial record and displays the 2nd row which is all nulls. All other records show correctly.

      Below is the HTML from the resulting page for the init_row of the report. I understand why it is behaving this way, however I have no idea how to make the style of the first <tr> carry over into the 2nd row of the record.
      <tr id="init_row_R1009150109271352230" style="display:none;" >
      <td rowspan="2"><a href="javascript:ShowRegion('')" >(null)</a></td>
      <td rowspan="2">(null)</td>
      <td rowspan="2">(null)</td>
      <td rowspan="2"><label for="f04_0000" class="hideMeButHearMe">Completion Date#ROW_HEADER#</label><span style="white-space: nowrap;"><input type="text"  id="f04_0000" name="f04" maxlength="2000" size="12" value="" autocomplete="off"></span></td>
      <td><label for="f07_0000" class="hideMeButHearMe">Vacant#ROW_HEADER#</label><input type="text" name="f07" size="5" maxlength="2000" value=""  id="f07_0000" /></td>
      <td><label for="f08_0000" class="hideMeButHearMe">Delinked#ROW_HEADER#</label><input type="text" name="f08" size="5" maxlength="2000" value=""  id="f08_0000" /></td>
      <td><label for="f09_0000" class="hideMeButHearMe">Soft Dt#ROW_HEADER#</label><input type="text" name="f09" size="5" maxlength="2000" value=""  id="f09_0000" /></td>
      <td><label for="f10_0000" class="hideMeButHearMe">Ull Poi#ROW_HEADER#</label><input type="text" name="f10" size="5" maxlength="2000" value=""  id="f10_0000" /></td>
      <td><label for="f11_0000" class="hideMeButHearMe">Ported#ROW_HEADER#</label><input type="text" name="f11" size="5" maxlength="2000" value=""  id="f11_0000" /></td>
      <td><label for="f12_0000" class="hideMeButHearMe">Blocked#ROW_HEADER#</label><input type="text" name="f12" size="5" maxlength="2000" value=""  id="f12_0000" /></td>
      <td><label for="f13_0000" class="hideMeButHearMe">Path Vacant#ROW_HEADER#</label><input type="text" name="f13" size="5" maxlength="2000" value=""  id="f13_0000" /></td>
      <td><label for="f14_0000" class="hideMeButHearMe">Path Delinked#ROW_HEADER#</label><input type="text" name="f14" size="5" maxlength="2000" value=""  id="f14_0000" /></td>
      <td><label for="f15_0000" class="hideMeButHearMe">Path Soft Dt#ROW_HEADER#</label><input type="text" name="f15" size="5" maxlength="2000" value=""  id="f15_0000" /></td>
      <td><label for="f16_0000" class="hideMeButHearMe">Path Ull Poi#ROW_HEADER#</label><input type="text" name="f16" size="5" maxlength="2000" value=""  id="f16_0000" /></td>
      <td><label for="f17_0000" class="hideMeButHearMe">Path Ported#ROW_HEADER#</label><input type="text" name="f17" size="5" maxlength="2000" value=""  id="f17_0000" /></td>
      <td><label for="f18_0000" class="hideMeButHearMe">Path Blocked#ROW_HEADER#</label><input type="text" name="f18" size="5" maxlength="2000" value=""  id="f18_0000" /></td>
      Any ideas to try would be greatly appreciated. I've tried using conditions on the #ROWNUM# values, but the null row is always there...

      And yes I know I shouldn't be using tabular forms, but sometimes what is wanted is not what is best... :-)


      Edited by: Snowman on Dec 4, 2012 3:12 PM

      Edited by: Snowman on Dec 4, 2012 3:13 PM
        • 1. Re: Named column report template with 2 rows/record displays null row at top
          See +{thread:id=1116477}+

          Sorry, I forgot about this when I suggested you could use a custom report template here (unsurprisingly, since I haven't used tabular forms since these changes were introduced).

          I don't recall seeing the potential customization mooted in 4.1 or 4.2 (but then I wouldn't as i don't have any such tabular forms).

          So your options appear to be:

          <li>Using nested tables as Marc suggests, which introduces Peter's drawback regarding column widths (you can try to remedy this using CSS to create fixed-width tables/columns but my last experience of this got very messy in terms of cross-browser and legacy IE support...)
          <li>Build the page completely manually without using any of APEX's built-in tabular form features.
          <li>Try to customize the add row behaviour to accommodate the custom layout using dynamic actions/jQuery.
          <li>Don't use tabular forms.
          • 2. Re: Named column report template with 2 rows/record displays null row at top
            Thanks again for your help.

            I'm going down the nested table route, as it seems to provide what I'm after.

            There is definitely no customisation in 4.1 for this 'bug', but this solution will be a lifesaver...