Return Last Item from a Table
I have a table with a set of numbers and dates. I'm only interested in the last number / date item in the results returned by a query. Any idea how I can get that single value out of the table and into a report through Report Studio? For example there is a list of numbers starting at 0 ending at 99. I only want to display the number 99 on a graph.
Thanks in advance.
Derry
Thanks in advance.
Derry
3 answers
What we did to get a single value from a list was to set a filter on one of the incoming data items. It was a date type so we filter on the 'maximum' date value which gives the latest date. YMMV on other data types. Does any know if there is a function to retrieve an item based on index or some other attribute?