I have a table in SSRS report. And I need to display only the last row of the table. ie,
How can I do this?
Asked
Active
Viewed 2,524 times
1
Ashkan S
- 10,464
- 6
- 51
- 80
-
Do you have any grouping on your rows or columns? – Alan Schofield Oct 21 '17 at 13:36
-
Yes. Row group is there – Oct 24 '17 at 04: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. – Alan Schofield Oct 24 '17 at 07:45
2 Answers
0
How do I select last 5 rows in a table without sorting? see this post, and change to "-1"
Schmocken
- 603
- 8
- 15
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);