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.

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

Just show last date with Report Builder 3.0 custom report

Accepted answer

Joyzhao-MSFT 15,566 Reputation points

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
Please sign in to rate this answer.
Adrian Hall 21 Reputation points

2020-08-26T17:29:17.51+00:00

Apologies i should have been clearer but its hard as i realize people might call some things differently. This screenshot which hopefully helps more. The something i referred to was for the third column relating to dates.

This is a basic report I've created to pull off information from our database where people have had any of three specific events added to them over time. I just need to know the date when the last of any of the events were added rather than them all. We are having people that are getting more than one event added to them and i just want the date and event name of the most recent one.

The two I've highlighted in green are examples of people with more than one of the events the report is looking at. I realize i can amend this in Excel but want to reduce that task for other users of the report so that they can just click and go with the results.

Adrian Hall 21 Reputation points

2020-08-26T17:34:55.433+00:00

Additionally i have tried some options already seen on here and another forum around MAX and LAST and it doesn't allow those when i add them unless I've added them in the wrong area/field. We have only recently moved to version 3 with little support on how to use it so i'm pushing at the ceiling of my knowledge on it right now.

Joyzhao-MSFT 15,566 Reputation points

2020-08-27T02:21:20.187+00:00

Hi,
Thanks for the description.
Just to double check, you want to have the last added event for each Client Name/Person right ?
You could do as follow,

Create a table and add a parent group, group by Client Name.

DELETE the detail group of the table.

Add Last(Fields!lastActualDate.value) and other last(fields!yourFields.value) in the table.
It should look like this :

Adrian Hall 21 Reputation points

2020-08-27T14:22:27.203+00:00

Thank you for this, it works though haven't done step three! Just shows what more i need to learn from this software as we progress.
Sign in to comment

Just show last date with Report Builder 3.0 custom report

0 additional answers