reporting-servicesssrs-2008ssrs-2012activereports

Show column value on new page regardless of whether it has changed

After a page-break I want the Name shown in the first column, which is hidden in all but the first row it appears in, to be shown again. Please run the following snippet to see what I mean. 

<html>
<h2>This Output I want to Achieve</h2>
<h3>On Current Page</h3>
<table>
<tr>
  <th>Name</th>
  <th colspan="2">Telephone</th>
</tr>
<tr>
  <td>Bill Gates</td>
  <td>555 5989</td>
  </tr>
  <tr>
  <td></td>
  <td>55545646</td>
  </tr>
  <tr>
  <td></td>
  <td>54513215</td>
  </tr>
  <tr>
  <td></td>
  <td>54542324324</td>
</tr> 
<tr>
  <td>Jeff</td>
  <td>987458</td>
</tr>
<tr>
<td></td>
  <td>324238</td>
</tr>
</table>

<h3>On Next Page</h3>

<table>
<tr>
  <th>Name</th>
  <th colspan="2">Telephone</th>
</tr>
<tr>
<tr>
  <td>Jeff</td>
  <td>987458</td>
</tr>
<tr>
<td></td>
  <td>324238</td>
</tr>

<tr>
<td>Sundar</td>
  <td>324238</td>
</tr>
<tr>
<td></td>
  <td>324238</td>
</tr>
</table>

<h2>But this output I am getting </h2>
<h3>On Current Page</h3>
<table>
<tr>
  <th>Name</th>
  <th colspan="2">Telephone</th>
</tr>

<tr>
  <td>Bill Gates</td>
  <td>555 5989</td>
  </tr>
  <tr>
  <td></td>
  <td>55545646</td>
  </tr>
  <tr>
  <td></td>
  <td>54513215</td>
  </tr>
  <tr>
  <td></td>
  <td>54542324324</td>
</tr> 
<tr>
  <td>Jeff</td>
  <td>987458</td>
</tr>
<tr>
<td></td>
  <td>324238</td>
</tr>
</table>

<h3>On Next Page</h3>
<table>
<tr>
  <th>Name</th>
  <th colspan="2">Telephone</th>
</tr>
<tr>
<tr>
  <td></td>
  <td>987458</td>
</tr>
<tr>
<td></td>
  <td>324238</td>
</tr>

<tr>
<td>Sundar</td>
  <td>324238</td>
</tr>
<tr>
<td></td>
  <td>324238</td>
</tr>
</table>
<html>

I want to Achieve this Output using SSRS Expression. I am working on Active Report .rdlx form.

Note 1:

I want output in .rdlx format not for Section Report .rpx Format .I want to achieve in Active Report 9 version

Note 2:

This question is about a SSRS Report (.rdlx) Active Report not HTML. I used HTML as a clear way to explain my question.

Solution

  • There are a couple of things you can do. First, in the latest version of ActiveReports 13, we've added an "AutoMerge" property to the Table control that will do this for you by default. Otherwise, if you'd like to stick to ActiveReports 9, you can get this behavior by using the Matrix control. We've provided a sample for you here.