Max date per group in SSRS

hi,

how select max row/date per group. planing @ report design level(i.e, trying put filter condition in group properties).

pl me in regard.

thanks

aneel

hi aneelchandra,

seems select max value in each group, right? if misunderstand, please let me know.

can use filter achieve target, please take following steps of sample reference.

1. add row parent group without select “add group header” , “add group footer”, and  then new group display in “row groups” pane , named group1.
2. right-click “details” in “row groups”, , select “group properties”.
3. change “filters” tab, click “add” button add filter following:
expression: [salesamount] (select data field choose max value it)
operter: =
value: =max(fields!salesamount.value,"group1")

after  completer steps above, result need.

if have question, please feel free ask.

thanks,
eileen

SQL Server  >  SQL Server Reporting Services, Power View