Page 1 of 1

Filtering the data of the latest date

Posted: Thu Dec 21, 2017 8:39 am
by horusshih
Hi

I want to filter the data of the latest date in a databand.

I've tried to use MaxDate function, but I don't know how to set the filter in a right way.

Are there any good advise to solve this problem?

Re: Filtering the data of the latest date

Posted: Fri Dec 22, 2017 7:03 am
by HighAley
Hello.

We can suggest you two solutions:

1. You could use Totals functions with CacheTotals enabled.
2. Use a variable.

Please, look at attached reports.

Thank you.

Re: Filtering the data of the latest date

Posted: Tue Dec 26, 2017 7:17 am
by horusshih
Hi HighAley

Using Totals functions works in my report.

Thanks for your suggestion.

Re: Filtering the data of the latest date

Posted: Tue Dec 26, 2017 10:46 am
by HighAley
Hello.

We are always glad to help you.
Let us know if you need our help.

Thank you.