0

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.

Dale K
  • 25,246
  • 15
  • 42
  • 71
Rahul Shukla
  • 37
  • 7
  • Trying to understand your question, are you asking how show the name again when there is a page break? – Dale K Feb 23 '19 at 06:35
  • When Particular ProductID ,Productname come on next page and it should display ProductID on next Page .I used this Expression but its not working =iif(Previous (Fields!PShopNm.Value) = Fields!PShopNm.Value Or Fields!PShopNm.Value < 9999 ," ",Fields!PShopCd.Value + " " + Fields!PShopNm.Value) – Rahul Shukla Feb 23 '19 at 06:38
  • OK - thats confusing, because your example has name & telephone. So to check, its your expression which is suppressing the name in subsequent rows after its first displayed? Please add all this additional information directly to your question to clarify for anyone reading it. – Dale K Feb 23 '19 at 06:45
  • are you grouping the table by Name? Can you please email our support to look into it. This looks like it needs a page-level expression since showing or hiding is based on the page break. – GrapeCity Team Feb 23 '19 at 06:58
  • Based on the OP's last comment I think they aren't grouping at all - which will be the cause of the problem. – Dale K Feb 23 '19 at 07:11
  • @DaleBurrell =iif(Previous (Fields!Name.Value) = Fields!Name.Value ," ",Fields!Name.Value ) This is my Expression as i Shown you in Example but it's not displaying on next page it's Showing one time which is ok but I want to display on next page when Name of same telephone number is connecting on Next Page, I hope I cleared your doubts – Rahul Shukla Feb 23 '19 at 07:42
  • Please update the question with clarifications - not add comments. – Dale K Feb 23 '19 at 07:44
  • The answer is, don't use an expression to hide the repeated value of `Name` instead `group by` `Name` and then set the `KeepTogether` flag on the group. – Dale K Feb 23 '19 at 07:44
  • ＠GrapeCity Team, Sir I connected to your support then won't find solution for .rdlx expression they are saying we have to do in .rpx format to achieve ths output ,it's not possible in .rdlx format report – Rahul Shukla Feb 23 '19 at 07:45
  • Unfortunately, that might be the only answer for now. However, we'll discuss with product team to see if we can add this feature in a future release. – GrapeCity Team Feb 23 '19 at 08:00
  • @DaleBurrell Sir Thanks for the solution but isn't worked for me. Please Suggest some Another solution – Rahul Shukla Feb 23 '19 at 08:04
  • https://stackoverflow.com/a/38527069/1127428 – Dale K Feb 23 '19 at 08:09
  • In My Active Report Table Property there no such option of Keep together @DaleBurrell – Rahul Shukla Feb 23 '19 at 09:05
  • 1
    I think you probably shouldn't have tagged reporting services - because from what I can tell you're not using regular reporting services. – Dale K Feb 24 '19 at 01:23
  • there is a Matrix control in ActiveReports 9 that allows to get the desired output. i have uploaded a sample of report on dropbox: https://www.dropbox.com/s/6z0d1ozxo8wox7p/so54838759_matrix.rdlx?dl=0 – GrapeCity Team Feb 24 '19 at 04:32

1 Answers1

1

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.

GrapeCity Team
  • 837
  • 1
  • 5
  • 8