This discussion is archived
2 Replies Latest reply: Dec 4, 2012 4:04 PM by Snowman RSS

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

Snowman Newbie
Currently Being Moderated
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>Premises</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>
</tr>
<tr>
<td>Path</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>
</tr>
<tr>
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... :-)

Cheers,
Greg

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
    fac586 Guru
    Currently Being Moderated
    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
    Snowman Newbie
    Currently Being Moderated
    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...

    Cheers,
    Greg

Legend

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