topic Re: Max Date from a Column in a Paginated Report in Report Server

Max Date from a Column in a Paginated Report

i820017 — Tue, 23 Nov 2021 20:18:46 GMT

Hey Everybody,

I just created a paginated report from a Power BI report on the cloud.
Anyway, I only want the Max date to show up for the column 'Date Last Quoted' for each Sales Rep. My report shows all of the dates for each Sales Rep as seen below when I use Max. Here is the expression that I used to get the 'Date Last Quoted' column =Max(Fields!QUOTE_CREATE_DT.Value)

Does anyone know what I can do to only get the Max Date? In this case,10/13/2021

Thanks

Dan

Re: Max Date from a Column in a Paginated Report

FarhanAhmed — Wed, 24 Nov 2021 03:39:58 GMT

MAX will work on the grouping of data... Did you create groups in your table Matrix ?

Add Grouping To Table Reports In SSRS (tutorialgateway.org)

Re: Max Date from a Column in a Paginated Report

i820017 — Wed, 24 Nov 2021 14:20:02 GMT

Yes, I created groups in my SSRS report. Moreover, I tried grouping by 'Date Last Quoted' and that didn't work for me. How do you group with dates in SSRS?

Re: Max Date from a Column in a Paginated Report

AbhiSSRS — Wed, 08 Dec 2021 10:54:10 GMT

Hi!

Please run this in context of the dataset eg " =Max(Fields!Month.Value, "Main") where Main is the dataset name.

Ideally your expression should have worked as the tablix would have bound to the dataset directly. Please let us know on your daataset details in case this dsn't work

Re: Max Date from a Column in a Paginated Report

mohammadyousaf — Tue, 10 Oct 2023 12:07:45 GMT

worked, thank you.