Change the displayed value when repeated on a new page.

Question

I have a group that's set to "RepeatOnNewPage" = "True"... And that's working fine...

What I would like to do is be able to append "(contunued...)" after the value when it is being repeated.

Something like this... If "IsRepeatedFromPrevPage" were a real function...

=IIf(IsRepeatedFromPrevPage(Fields!CompanyName.Value) = True, Fields!CompanyName.Value & "(Continued...)", Fields!CompanyName.Value)

Any ideas?

---

Jason Long

Answer 1

You can use the previous function.

=IIF(Previous(Fields!CompanyName.Value)=Fields!CompanyName.Value, Fields!CompanyName.Value & "(Continued...)", Fields!CompanyName.Value)

---

Please mark as answered or vote helpful if this post help resolved your issue. Thanks!

k r o o t z

Answer 2

Krootz,

Thanks for the reply. I gave your suggestion a try but it's throwing back an[rsInvalidAggrigateScope] error.

[rsInvalidAggregateScope] The Value expression for the text box ‘textbox11’ has a scope parameter that is not valid for an aggregate function.  The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a dataset.

---

Jason Long

Answer 3

Hi Jason,

From your description, the row group groups on the CompanyName field. If the first instance of the row group expands to multiple page such as 3 pages, you want to display the Fields!CompanyName.Value on the first page, and Fields! CompanyName.Value & “(Countinue …)” on the second and the third page. And so on, for each instance of the row group. Right? If so, I am afraid this cannot be done in SSRS currently. Since the column headers of a tablix are not in the scope of the row group, the Previous() function won’t work, and there is not such a function provided by current release of SSRS.

I would suggest you submitting a wish at https://connect.microsoft.com/sql.

Connect site is a connection point between you and Microsoft, and ultimately the larger community. Your feedback enables Microsoft to make software and services the best that they can be, and you can learn about and contribute to exciting projects.

Regards, 

---

Mike Yin
TechNet Community Support