Just show last date with Report Builder 3.0 custom report

Adrian Hall 21 Reputation points
2020-08-25T16:29:49.727+00:00

Is there anyway to just show the last date something was added within the report builder as in reports I am getting multiple results when I just want the date of the last one added.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,138 questions
No comments
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,361 Reputation points Microsoft Employee
    2020-08-26T02:27:46.767+00:00

    Hi,
    Could you be more specific what is this "something"?

    Was this a field ? You could find it by Max(Fileds!dateColumn.value). For only showing that row, you could use visibility expression as :

    =IIF(Fileds!dateColumn.value=Max(Fileds!dateColumn.value), false, true)
    

    If it is an report item, we could not know if it is last added into the report design.
    You could add more details or screenshot so we could understand you design or issue better.
    Regards,
    Joy


0 additional answers

Sort by: Most helpful