1

I have a table in SSRS report. And I need to display only the last row of the table. ie, Please refer the Image below

How can I do this?

3
  • Do you have any grouping on your rows or columns? Commented Oct 21, 2017 at 13:36
  • Yes. Row group is there Commented Oct 24, 2017 at 4:19
  • You really need to provide a bit more info. Edit your question to show your row group and describe how you order this group. It's not easy to answer your question with so little to go on. Commented Oct 24, 2017 at 7:45

2 Answers 2

0

How do I select last 5 rows in a table without sorting? see this post, and change to "-1"

Sign up to request clarification or add additional context in comments.

1 Comment

The value in the table is dynamic. It can change.
0

We can select the last row of the table by using Last() method. For eg. if we have a table called Test then,

Last(Fields!Test.value); 

Comments